Herzlich willkommen

How to clone a Magento MySQL database

Created at: 11 Mar 2016 Updated at: 20 Oct 2020

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