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 votes111 views1 answer
How to select first row of database sql
SQL
20 votes110 views5 answers
Mysql reset auto increment to 1
SQL
1 vote121 views1 answer
Psql lst trigger
SQL
7 votes117 views1 answer
Alter sequence set current value oracle
SQL
0 vote126 views1 answer
Convert .mdf to .bak
SQL
0 vote118 views1 answer
Use between operator in mysql
SQL
0 vote77 views1 answer
Postgresql add leading zeros
SQL
2 votes114 views1 answer
Oracle trace session
SQL
6 votes106 views1 answer
Allsource oracle
SQL
0 vote119 views1 answer
Case insensitive sql
SQL