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

-2 votes355 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote360 views1 answer
How to make sure two tables have same exact data in sql
SQL
1 vote321 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote312 views1 answer
Resulting Query
SQL
0 vote342 views1 answer
Hibernate show sql xml property
SQL
6 votes320 views2 answers
Mysql check auto increment value
SQL
0 vote367 views1 answer
Acutal month year
SQL
8 votes369 views3 answers
SQL column name
SQL
0 vote358 views1 answer
Spark sql grows beyond 64 kb
SQL
10 votes326 views1 answer
Create table oracle
SQL