6. Tools‎ > ‎

1. Database Backup and Restore

fmAutoBackupRestore , fmProductExport , fmProductImport , fmBackupRestoreWizard

Maintaining a VirtueMart 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 current store database
  • Restore over current backup
  • Backup multiple stores


Backup current store database

You can backup your VirtueMart 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 current store database" and hit next to proceed.

 2. Specify any file name and directory for the backup.




 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.


4. Backup database structure only (no data) allows you to save database structure only (tables with no data) into the .sql file. 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.


Attention! By clicking "Backup" button you're saving the script into the file selected before.

5. 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 over current backup

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

    Select "Restore over current database" option.

 
2. Specify the backup file name and path to restore from.

 
3. Backup preview step allows you to check the backup script. Click 'Next' to proceed the restore procedure.



4. Force clear database before script execution allows you to clear default data from your store and to restore the backup.

 You can save restore configuration in the appropriate field  at the bottom of 'Options' window.

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.

5. 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.

Backup multiple stores

Using this tool you can backup multiple stores you have:
  1. Go to Tools -> Database Backup/Restore wizard. Select "Backup multiple stores" option.


     
  2. Specify any file name and directory for the backup. There you will see the databases you have. Check the ones for which you'd like to make backup.


     
  3. The last step shows you the result. Here you can see if any error occurs while creating backup.


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

By eMagicOne Inc.

Comments