Duplicating databases

Duplicating the databases

- Create a new database, db2
- Run this command:

mysqldump -h [server] -u [user] -p[password] db1 | mysql -h [server] -u [user] -p[password] db2

Reference 

http://blog.csmonkey.com/2009/03/how-to-duplicate-mysql-database.html