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

4 votes203 views1 answer
Id increment ms sql server
SQL
1 vote210 views1 answer
Insert value to new table by joining 2 different tables
SQL
3 votes187 views1 answer
Postgres kill running query
SQL
2 votes182 views1 answer
Sqlplus clear screen
SQL
0 vote190 views1 answer
Mysql drop multiple tables at once
SQL
-1 vote149 views2 answers
On delete set default sql server
SQL
5 votes185 views1 answer
Ora-00054 find lock
SQL
22 votes205 views3 answers
Remove all records from table mysql
SQL
0 vote202 views1 answer
Create domain sql
SQL
15 votes174 views4 answers
T-sql drop function if exists
SQL