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