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 vote236 views1 answer
Convert int to varchar sql
SQL
0 vote223 views1 answer
Mysql group by derived column
SQL
7 votes215 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote219 views1 answer
Check if a word appears at the end sql query
SQL
2 votes241 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote240 views1 answer
Where date in datetime mysql
SQL
3 votes493 views1 answer
Postgresql cast
SQL
3 votes191 views2 answers
Mysql sum with condition
SQL
4 votes236 views1 answer
What are the data types in sql
SQL
2 votes244 views1 answer
Ssh mysql port forwarding
SQL