How to clone a Magento MySQL database

On the server command line, create a database dump and import this dump into a new database.

Export:

$ mysqldump -u USERNAME -p EXISTING_DBNAME > DUMP.sql

Re-Import:

$ mysql -u USERNAME -p NEW_DBNAME < DUMP.sql