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 vote202 views1 answer
Logtash mysql cofiguration file
SQL
1 vote273 views1 answer
Top 10 rows in mysql
SQL
0 vote234 views1 answer
Mariadb alter table add column if not exists example
SQL
8 votes186 views1 answer
Unique vs primary key
SQL
0 vote989 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote179 views1 answer
Dump only schema
SQL
0 vote190 views1 answer
Wp_query raw sql
SQL
-1 vote194 views1 answer
Get id from just inserted row mysql server python
SQL
-1 vote251 views4 answers
Postgres between dates
SQL
20 votes205 views4 answers
Reset auto increment in MySQL
SQL