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

37 votes150 views3 answers
Postgresql insert column
SQL
0 vote177 views1 answer
C# select Mysql
SQL
1 vote167 views1 answer
Mysql not supported auth mode
SQL
5 votes143 views1 answer
Sqlite alter table add column
SQL
0 vote171 views1 answer
Update database collation in postgresql
SQL
0 vote152 views1 answer
Oracle procedure chain step
SQL
0 vote157 views1 answer
Oracle db timestamp auto add
SQL
0 vote352 views1 answer
Sql datum formatieren
SQL
0 vote168 views1 answer
How to print some string in mysql
SQL
0 vote163 views1 answer
Como hacer una consulta en sql
SQL