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 vote297 views1 answer
Sql server order by nulls last
SQL
25 votes352 views1 answer
How to update an attribute in MySQL
SQL
0 vote293 views1 answer
Mysql money value
SQL
0 vote305 views1 answer
Narural join
SQL
49 votes349 views6 answers
Alter table add column
SQL
0 vote293 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote334 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote302 views1 answer
Azure sql server check foreign key
SQL
1 vote292 views1 answer
Oracle sql create or replace view
SQL
0 vote320 views1 answer
Sql update subtract value
SQL