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 vote269 views2 answers
Android sqlite tutorial for beginners
SQL
6 votes299 views4 answers
Mysql group by month
SQL
62 votes359 views8 answers
Mysql add column
SQL
8 votes311 views2 answers
Update sql server from another table
SQL
0 vote309 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote270 views1 answer
Sql server split string and insert into table select
SQL
2 votes267 views1 answer
Create table with primary key
SQL
0 vote257 views1 answer
Clone table structure mysql
SQL
3 votes317 views2 answers
Synonym oracle
SQL
1 vote281 views1 answer
Launch sql script from docker in mysql
SQL