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

20 votes130 views6 answers
Change password in mysql
SQL
1 vote137 views1 answer
Tsql replace value in json
SQL
0 vote130 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote129 views2 answers
Create row number in sql
SQL
0 vote138 views1 answer
Postgresql create query
SQL
20 votes132 views5 answers
Mysql reset auto increment to 1
SQL
1 vote190 views1 answer
Sql server delete top 1000
SQL
6 votes118 views2 answers
Mysql version check cmd
SQL
0 vote138 views1 answer
Get schema of table sql
SQL
19 votes130 views6 answers
Laravel sql query
SQL