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 vote184 views1 answer
Doctors appointment
SQL
0 vote146 views1 answer
Joins vs includes
SQL
3 votes143 views1 answer
Sql server check version
SQL
0 vote150 views1 answer
Sql query use select name inside where clause
SQL
11 votes148 views1 answer
Ddl view
SQL
3 votes147 views2 answers
Sqlite show table structure
SQL
2 votes147 views2 answers
Sql query to copy data from one column to another
SQL
0 vote140 views1 answer
Mysql add to number
SQL
1 vote137 views1 answer
Crontab every month
SQL
0 vote131 views1 answer
Postgresql newline character
SQL