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

13 votes124 views2 answers
Sql online compiler
SQL
2 votes129 views1 answer
Mysql id of inserted row
SQL
1 vote119 views1 answer
Sql server locks
SQL
0 vote126 views2 answers
Timing sql queries
SQL
1 vote121 views1 answer
Print all records of table in mysql
SQL
0 vote115 views1 answer
Convert sql server guid to varbinary
SQL
0 vote114 views1 answer
SQL column name Oracle
SQL
0 vote106 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote70 views1 answer
Alter session set nls_language french
SQL
5 votes123 views1 answer
Commentaire table oracle
SQL