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

12 votes280 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote280 views1 answer
Oracle date summer time
SQL
2 votes279 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote283 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote290 views1 answer
Create query in where clasue
SQL
1 vote267 views2 answers
How to drop a unique constraint in sql
SQL
0 vote312 views1 answer
Mysql where don't have string
SQL
0 vote298 views1 answer
How to check which table has data in mysql
SQL
0 vote296 views2 answers
Advantages of stored procedures sql
SQL
0 vote278 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL