Whether you’re an experienced store owner or a newbie, by now you should’ve already come to terms with having to create backups before each small or significant website modification (e.g., Magento database migration). It is, in fact, a rule of proper website management.

Migration of data, especially for large businesses, is a complicated and, at times, risky procedure. So, Cart2Cart takes the security aspect of it very seriously. We create backups on your source and target stores before each Magento database migration and even before the free Demo migration (if you choose so).

However, some might still want to go the extra mile and create database backups independently. Understandably - that’s the one kind of paranoia we fully endorse. If you happen to be a Magento running security freak, the following post is just for you. It describes two simple ways of making data backups and restoring stores from them properly during the Magento database migration.

Magento Database Migration: How to Backup and Restore Files in a Few Simple Steps

Magento 1.x Version

Database Backup

Despite the overall complexity Magento brings, the procedures of backing up and restoring data are relatively straightforward:

  1. Log in to your Magento admin panel
  2. Step to System → Tools → Backups
  3. Magento Database migration
  4. You will see three options there - System Backup, Database and Media backup, Database backup
  5. Restore Magento Database

    System Backup is the most radical one - it’ll pack your entire source code with database into one tar archive.

    Database and Media backup will save your database and media folder’s content. Entities like store themes are not included.

    Finally, Database Backup is self explanatory - it will take your Magento store data dump.

  6. See for yourself which option to choose, and click one of the orange buttons.
  7. Confirm your intention in the Warning window and specify the backup name in the box that’ll appear next.
  8. Magento Database migration

    Also, you can turn the maintenance mode on while the procedure is in progress. We recommend putting a tick next to it so that no database changes happen while you are backing it up.

  9. Wait till the Database backup has been created! message appears on the screen. When it happens, pat yourself on the back - you’ve done well.

Besides Magento’s dashboard, you can log in to your hosting admin panel and backup database from there.

Since lots of our users seem to use cPanel, we’ll take it as an example:

  1. Log in to admin panel, find the Files section and press Backups
  2. Magento Database migration
  3. Again, choose for yourself what kind of website backup to create - full, partial, or just the database backup. In case of the most later option - click on on the name of the needed database.
  4. Restore Magento Database
  5. That’s it, in a few minutes look for the database archive in your Downloads folder.

Restore Data from Database Backup

Restoring Magento databases doesn’t deserve a separate instruction since the entire procedure consists of one step.

In Magento admin panel:

Navigate to System → Tools → Backups, pick the needed backup from the list and click Rollback

In your hosting’s cPanel:

Go to Backups in the Files section, under Restore a Database MySQL Backup, upload your backup archive.

Further read: Magento Data Migration: Roadmap for Non-Technical Users [2020]

Magento 2.x Version

How to Backup the Database?

  1. Open your Magento admin panel
  2. Go to System → Tools → Backups
  3. Choose the type of backup you wish to create (i.e., System Backup, Database and Media backup, Database backup) and tap on the corresponding button in the right upper corner
  4. Set the backup name. Also, we recommend you to put your store to the maintenance mode.
  5. Note: Magento database backup may take from 20 sec. up to a few minutes. It usually depends on the database size, server capabilities, etc.
  6. Once done, click the Ok button

How to Restore the Database?

  1. Go to the Backups menu in the Admin panel
  2. Select the necessary backup file you wish to restore and click on the Rollback link
  3. After that you will receive the system warning. Tap Ok to proceed with the rollback
  4. Fill in your User password and put the store into the maintenance mode by ticking the corresponding box
  5. Click the Ok button to start the rollback

These are not the only methods to backup and restore the Magento database but certainly the easiest ones. Should you have other suggestions on the subject, please share them in the comment box.

If you'd like to perform the Magento database migration, Cart2Cart will gladly lend you a helping hand. Do not hesitate to run a free Demo now!