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 vote201 views2 answers
Connect to mysql server mac terminal
SQL
1 vote179 views1 answer
Psql filed name alter
SQL
2 votes186 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote187 views1 answer
Database traccar
SQL
4 votes185 views2 answers
Sql offset
SQL
0 vote196 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
5 votes184 views2 answers
Sql constraint check value in list
SQL
8 votes183 views3 answers
Oracle auto_increment
SQL
15 votes189 views4 answers
Create table if not exists sql
SQL
9 votes189 views2 answers
Nosql databases
SQL