How to clone a Magento MySQL database
Created at: 11 Mar 2016 | Updated at: 1 Mar 2021
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
Categories: Magento 1 / OpenMage