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

27 votes327 views6 answers
Set password mysql
SQL
4 votes314 views3 answers
Postgres set default value
SQL
0 vote316 views1 answer
Dump db only triggers mysql
SQL
0 vote344 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote326 views1 answer
Apache Derby: Create SQL Dump with data
SQL
2 votes342 views1 answer
Coalesce sql
SQL
0 vote343 views1 answer
Hex string sql becomes int64
SQL
0 vote300 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote317 views1 answer
Group_concat only returns one row
SQL
1 vote326 views3 answers
Execute sp in sql server
SQL