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

1 vote249 views1 answer
Oracle show execution plan
SQL
0 vote230 views1 answer
Lost connection to mysql
SQL
1 vote206 views2 answers
Populate sql table with random data
SQL
0 vote209 views1 answer
Sql fetch next 10 rows pdo
SQL
0 vote204 views2 answers
Cascade syntax in sql
SQL
0 vote224 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote212 views1 answer
Sql max min
SQL
1 vote207 views2 answers
T-sql random number for each row
SQL
2 votes207 views2 answers
Exec procedure pl sql
SQL
1 vote220 views2 answers
Sql multiline comment
SQL