14Jul/101

Quickly & Easily Backup Your Entire Magento MySQL Database

We have used this command to successfully and quickly duplicate a Magento production site before upgrading it.

IMPORTANT:

  • You must run this command via SSH as a user with permission to access your MySQL databases.
  • The destination database must exist

Here is the command to run via SSH:

mysqldump -u mysqlusername --password=mysqlpassword sourcedatabase | mysql -u mysqlusername --password=mysqlpassword destinationdatabase

About John Webber

John is the founder of MagThemes.com and has been working with Magento since version 0.9
Comments (1) Trackbacks (0)
  1. We have used this command extensively to backup Magento databases when doing an upgrade or server move. It has always worked great.


Leave a comment


No trackbacks yet.