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

6 votes131 views5 answers
Sql add months to date
SQL
2 votes87 views1 answer
Sql select min value from multiple columns
SQL
0 vote181 views2 answers
Mysql cast to varchar
SQL
0 vote152 views1 answer
Jooq replace
SQL
0 vote113 views1 answer
Concat column value of same user in mysql
SQL
5 votes133 views2 answers
Oracle find all tables with column name
SQL
0 vote158 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
-1 vote160 views4 answers
Sql view postgresql
SQL
0 vote132 views1 answer
How to display value of variable in mysql
SQL
1 vote117 views1 answer
Influxdb export to csv
SQL