Copy database mysql

Mariadb clone database to another name

// if you didnt create the target db, do it:
mysql -u your_user -p

> CREATE DATABASE the_db_cloned_name;
> SHOW DATABASES

// then check if it is created and so you're ready to proceed
mysqldump -u your_user -p the_db_name > /directory/file_name.sql
mysql -u your_user -p the_db_cloned_name < /directory/file_name.sql

Source: mysqltutorial.org

Copy database mysql

mysqldump -u root -p db_caweb | mysql -u root -p root db_caweb_23012021;

Source: stackoverflow.com

Similar codes

0 vote244 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote291 views1 answer
For select oracle
SQL
5 votes275 views4 answers
Start postgres server
SQL
0 vote259 views1 answer
Datetime postgres typeorm
SQL
0 vote274 views1 answer
MySQL INSERT IGNORE Statement
SQL
2 votes251 views1 answer
Mysql how to store lat,lng
SQL
21 votes247 views6 answers
Docker run mysql
SQL
0 vote240 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote267 views1 answer
Sqlalchemy orm duplicate
SQL
1 vote252 views1 answer
Alter table column size oracle
SQL