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

2 votes144 views1 answer
Drop table if exists in postgres
SQL
1 vote149 views3 answers
Mysql disable foreign keys check
SQL
8 votes207 views2 answers
Oracle auto increment primary key
SQL
4 votes149 views3 answers
Postgres set default value
SQL
5 votes157 views4 answers
Change auto increment mysql
SQL
1 vote135 views1 answer
Set id count mysql
SQL
1 vote145 views1 answer
Expression number 1 of select list is not in group by clause
SQL
3 votes147 views1 answer
Postgres count distinct
SQL
0 vote153 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote141 views1 answer
Postgres add prefix to primary key
SQL