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

6 votes314 views2 answers
Difference between join vs union
SQL
0 vote335 views1 answer
Delete hangfire retries list
SQL
15 votes286 views2 answers
Sql order by multiple columns
SQL
12 votes278 views3 answers
Duplicate a column in sql
SQL
3 votes267 views1 answer
Sql cast to integer
SQL
0 vote335 views1 answer
Mysql create index lost connection
SQL
3 votes291 views1 answer
Oracle revoke grant
SQL
4 votes294 views1 answer
Oracle select first 10 rows
SQL
0 vote283 views3 answers
Above average salary in sql
SQL
1 vote299 views3 answers
Sql server get week dates from week number
SQL