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 vote146 views1 answer
Mysql create pool
SQL
0 vote132 views1 answer
Sql random decimal
SQL
0 vote162 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote110 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
1 vote146 views2 answers
Sql left characters
SQL
1 vote156 views1 answer
Second last highest id in sql
SQL
4 votes181 views1 answer
Rename stored procedure in sql server
SQL
3 votes101 views1 answer
Postgresql where current year
SQL
0 vote136 views1 answer
Remove default constraint sql server
SQL
0 vote114 views1 answer
How to check oracle index table
SQL