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

1 vote358 views2 answers
List tables sqlalchemy
SQL
4 votes344 views1 answer
Sql delete where in select
SQL
0 vote399 views1 answer
What is metadata in sql
SQL
-1 vote370 views8 answers
Create Trigger in phpMyAdmin
SQL
-1 vote359 views1 answer
How to dump .csv file into mysql
SQL
5 votes353 views3 answers
Select tables from mysql database
SQL
5 votes331 views6 answers
Sql add days to date
SQL
0 vote360 views1 answer
Select insert new table sql server
SQL
11 votes329 views2 answers
Having keyword sql
SQL
1 vote406 views1 answer
How to check all scheduled jobs in oracle
SQL