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 votes205 views2 answers
Run mysql command from bash
SQL
1 vote200 views1 answer
Partition by sql server
SQL
5 votes193 views1 answer
Minecraft java port number
SQL
0 vote259 views1 answer
Mysql subtract month from timestamp
SQL
0 vote202 views1 answer
How to see password mysql vestacp
SQL
1 vote203 views1 answer
Oracle start job
SQL
0 vote202 views1 answer
Group by sql not ordering issues
SQL
1 vote201 views1 answer
Postgresql convert text to float
SQL
0 vote193 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote193 views1 answer
NLS_NCHAR_CHARACTERSET
SQL