How to copy content from one database to another
or
how to duplicate database
For doing this you need:
1. Copy database to file:
mysqldump -u username -p password database_to_copy_from > FILE.sql
2. Create new database. I preffered GUI tools like MySQL Control Center. Or use next comands:
mysql> CREATE DATABASE ”database_to_copy_to”;
mysql> GRANT ALL PRIVILEGES ON ”database_to_copy_to”.* TO “”username””@””hostname”” IDENTIFIED BY “”password””
mysql> FLUSH PRIVILEGES;
mysql> EXIT
3. Copy database from file to new database
mysql -u username -p password database_to_copy_to< FILE.sql
Related posts:
