Answers for "copy database mysql"

SQL
1

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
Posted by: Guest on September-03-2020
0

copy database mysql

mysqldump -u root -p db_caweb | mysql -u root -p root db_caweb_23012021;
Posted by: Guest on January-24-2021

Code answers related to "copy database mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language