I want to backup and restore only important data from database.

Do you which tables are must have or any other idea how to restore?

Thank you

  • What is "important"? The store only consists of orders, (creditmemo, quotes, shipping data), products (attributes, configurable connectisons, images, ...) and customers with their click pathes, voting, etc. Sep 29, 2015 at 20:01

3 Answers 3


Back up the entire thing.

Not to be flippant, but if you don't already know which tables are important then they all are.

  • This cannot be emphasized enough. If you don't know what you're doing, don't mess around with individual tables.
    – laketuna
    Feb 19, 2015 at 4:59

this is really not a good idea to split the database backup. It really doesnt take very long to dump the database. If your concerned, what about running a mysql master and slave database, and then dumping the slave database.

Also suggest backing up off the server, I use a small script s3cmd which allows me to dump the database and backup to S3 all in one go. It also allows you to keep days/weeks/months of sql backups



As stated, you shouldn't split up the Magento database. If you've really got your heart set on it, you'll want to spend some time looking at http://www.magereverse.com/ . You will need to be sure that a partial DB backup won't cause issues elsewhere due to constraints. Not an endeavor for the faint of heart.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.