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 votes92 views2 answers
Create table if not exists postgres
SQL
8 votes144 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote130 views1 answer
Sql with example
SQL
0 vote132 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote148 views2 answers
What is the default password for sql server sa
SQL
1 vote210 views1 answer
Create new table from old table with data
SQL
1 vote142 views1 answer
Sql server update column based on another table
SQL
1 vote146 views1 answer
Drop primary key oracle
SQL
16 votes149 views1 answer
Mysql smallint range
SQL
6 votes144 views2 answers
Where clause in sql
SQL