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

0 vote105 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
9 votes98 views3 answers
Mysql get last id
SQL
16 votes109 views3 answers
Jwt secret key generator laravel
SQL
0 vote109 views1 answer
Sql mod even odd
SQL
4 votes103 views1 answer
Delete record mysql query
SQL
0 vote100 views2 answers
Psql commande \gset
SQL
3 votes104 views4 answers
Ubuntu stop mysql
SQL
8 votes101 views2 answers
Between operator
SQL
0 vote98 views1 answer
Min:sec datediff mssql
SQL
0 vote108 views1 answer
How to use sqlcommand
SQL