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 vote255 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
1 vote171 views1 answer
Nested if in mysql
SQL
1 vote207 views1 answer
Oracle show execution plan
SQL
0 vote187 views1 answer
Sql how to get courses that i have made prerequisites
SQL
15 votes189 views2 answers
Select where duplicate mysql
SQL
0 vote180 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote195 views1 answer
SQL: calculate hours from two dates
SQL
27 votes202 views6 answers
Set password mysql
SQL
0 vote198 views1 answer
Get id if is not equal in certain table
SQL
0 vote200 views1 answer
Sql server convert to guid
SQL