Tools‎ > ‎

1. Database Backup and Restore

MainAutoImportForm - Database Backup and Restore Section


Maintaining a CubeCart backup and restore of your database is not only a good practice but a real necessity. Backing up the database allows recovery either partially or totally in case of an operating system, software, hardware failure or human mistakes. These can damage or make the database inoperative and the data inaccessible.

Database backup and recovery wizard gives you the ability to configure possible database backup and restore scenarios:
  • Backup entire database
  • Backup product related tables only
  • Backup customers and orders data
     
  • Restore from backup
  • Restore default database with initial data

Backup entire database

You can backup your CubeCart database (create .sql file) using Backup entire database option. Follow few steps to create the backup:
  1. Go to Tools -> Database Backup/Restore wizard:



    Select "Backup entire database" and hit next to proceed.
     
  2. Specify any file name and directory for the backup.



    Also you can save all shopping cart files and make exceptions if needed. Note that you should have FTP connection established in order to download files. Also note that it will slow-down the process.
     
  3. Select tables you would like to backup. Most likely all tables will be checked, but you can check or uncheck any tables according to your needs.



    Backup database structure only (no data) allows you to save database structure only (tables with no data) into .sql file.
    Attention! By clicking "Backup" button you're saving the script into the file selected before.
     
  4. The last step shows you the backup file.



    That's it. The backup is saved into the file specified above. Click finish to close the wizard.

Backup product related tables only

You can backup CubeCart product related tables into .sql file using corresponding option. Follow few steps to create the backup:
  1. Go to Tools -> Database Backup/Restore wizard:



    Select "Backup product related tables only" option and hit next to proceed.
     
  2. Specify any file name and directory for the backup.



    Also you can save all shopping cart files and make exceptions if needed. Note that you should have FTP connection established in order to download files. Also note that it will slow-down the process.
     
  3. Select tables you would like to backup. Product related tables will be checked, but you can check or uncheck any tables according to your needs.



    Backup database structure only (no data) allows you to save database structure only (tables with no data) into .sql file.
    Attention! By clicking "Backup" button you're saving the script into the file selected before.
     
  4. The last step shows you the backup file.



    That's it. The backup is saved into the file specified above. Click finish to close the wizard.

Backup customers and orders related tables only

You can backup CubeCart customers and orders related tables into .sql file using corresponding option. Follow few steps to create the backup:
  1. Go to Tools -> Database Backup/Restore wizard:



    Select "Backup customers and orders related tables only" option and hit next to proceed.
     
  2. Specify any file name and directory for the backup.



    Also you can save all shopping cart files and make exceptions if needed. Note that you should have FTP connection established in order to download files. Also note that it will slow-down the process.
     
  3. Select tables you would like to backup. Customers and orders related tables will be checked, but you can check or uncheck any tables according to your needs.



    Backup database structure only (no data) allows you to save database structure only (tables with no data) into .sql file.
    Attention! By clicking "Backup" button you're saving the script into the file selected before.
     
  4. The last step shows you the backup file.



    That's it. The backup is saved into the file specified above. Click finish to close the wizard.

Restore from backup

In case you have previously saved database backup, you can restore it if needed. Follow few steps to restore a CubeCart backup over the current database:
  1. Go to Tools -> Database Backup/Restore wizard:



    Select "Restore from Backup" option and hit next to proceed.
     
  2. Specify the backup file name and path to restore from.


     
  3. Backup preview step allows you to check the backup script.



    Force clear database before script execution allows you to clear default data from your store and to restore the backup.
    Attention! By clicking "Restore" button you're restoring the script over your current database. Please note that you will not be able to undo the restore unless you've got a backup of your original database.
     
  4. The last step shows you the result. Here you can see if any error occurs while execution.



    That's it. The restore is completed. Click finish to close the wizard.

Restore default database with initial data

In case you would like to restore default CubeCart script over your embedded database or over your current store database, can use restore default database option. Follow few steps to restore default script over the current database:
  1. Go to Tools -> Database Backup/Restore wizard:



    Select "Restore default database with initial data" option and hit next to proceed.
     
  2. Backup preview step allows you to check the backup script with default database.



    Attention! By clicking "Restore" button you're restoring the script over your current database. Please note that you will not be able to undo the restore unless you've got a backup of your original database.
     
  3. The last step shows you the result. Here you can see if any error occurs while execution.



    That's it. The restore is completed. Click finish to close the wizard

By eMagicOne Inc.

Comments