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 vote204 views2 answers
Snowflake alter column data type
SQL
1 vote179 views1 answer
Apex run 404
SQL
2 votes209 views2 answers
Create table mysql integer NOT null
SQL
0 vote198 views1 answer
Template MySQL Zabbix agent
SQL
3 votes196 views1 answer
Locate sql server
SQL
4 votes241 views1 answer
How to check last gather stats on table in oracle
SQL
9 votes180 views2 answers
Default number in sql
SQL
0 vote196 views2 answers
Oracle sql for each row
SQL
1 vote184 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
0 vote185 views1 answer
Number(10 2) in sql means
SQL