Buscar este blog

lunes, 26 de marzo de 2012

How to duplicate a MySQL database

Let's say the original database is dbSouce and the duplicate is dbDestinatio.
- Login in MySql, Create a new database, dbDestination
- Set permissions new database.
- Run this command in console, for duplicate database

[root@LinuxServer ~]# mysqldump -u root -pMyPassword dbSouce | mysql -u root -pMyPassword dbDestination



 


Notice: There is no space between -p and the password.