Magento – Backup only orders, products, customers

backupdatabasemagento-1.9

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

Best Answer

Back up the entire thing.

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

Related Solutions

Magento – Best way to BACKUP

The absolute simplest method.

If you have SSH access and the disk space, the easiest way is to create a tarball (archive similar to windows Zip) of your webserver doc root and a compressed mysqldump of the database to a backup folder in your home directory (above your web server doc root so it's not web accessible).

Use SFTP to download the tarball and database backup to local storage. With only two files, it goes a lot quicker and is less likely to suffer errors than a long excruciating SFTP download of each individual file in the Magento installation.

Also, if you have Amazon Web Services, you can create an S3 bucket and use S3command to copy your backup files to that (goes the quickest)

(If you have a version of Magento that has System and Database backup, DO NOT USE THESE! They often knock your site offline with a 500 error do to messing with file permissions)

Magento – migrate products, categories, customers from 1.7.0.2 to 1.9.0.1

You can import Customers,Products and Categories from csv.

For customers and products , go to system > export/import.
For category csv export you can use this one http://www.magentoworks.net/import_categories.zip

Best Answer

Back up the entire thing.

Related Solutions

Magento – Best way to BACKUP

Magento – migrate products, categories, customers from 1.7.0.2 to 1.9.0.1

Related Topic