Our blog

 

Magento DB Dump – Just Use the Admin Backup – Not phpMyAdmin

This is as much a note to self as anything else. If you are migrating a Magento store or creating a copy of a store – if you use phpMyAdmin to create the database dump things can all go wrong.

Instead save yourself the hassle and just use the admin backups functionality. You can then import this using phpMyAdmin without any problems

More Reading:

2 Comments

Brian
September 22nd, 2010

What do I do when Magento Admin is having a terrible time making the backup? I get timeout errors, then 500 server errors after extending php max_execution_time. A backup through phpmyadmin was easy, but how do I tell if it will work if I need to restore?
 

admin
September 22nd, 2010

The Magento DB can grow really massive which causes these kinds of problems.

We made this extension to help with exactly these kinds of issues.

http://www.magentocommerce.com/magento-connect/edmondscommerce/extension/4440/edmondscommerce_lightbackup

Warning though, installing it does seem to trigger a full upgrade of Magento – we are still getting our heads round packaging Magento extensions properly.

Please install it on a test version and then copy the necessary files over (or if you are already running the latest Magento then this won’t be an issue)
 

 

Leave a Reply