Herzlich willkommen

How to clone a Magento MySQL database

Created at: 11 Mar 2016 | Updated at: 17 Jan 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