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 vote221 views1 answer
Excute raw query
SQL
0 vote229 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
3 votes231 views2 answers
How to load files in mysql
SQL
0 vote229 views2 answers
Sql use not in
SQL
15 votes327 views5 answers
Select all tables sql
SQL
40 votes265 views4 answers
PostgreSQL add column
SQL
1 vote220 views3 answers
Default password of mysql
SQL
0 vote245 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote218 views1 answer
Download mysql database to excel in android studio
SQL
4 votes261 views1 answer
Rename stored procedure in sql server
SQL