One of the most devastating events that can happen to an online store is the loss of a database. The store database contains important customer and product information. Create A Shoppe lets you download a backup of your store’s current database or restore the database using the built in backup/restore tool.
BACKUP YOUR STORE DATABASE
In the right menu click Tools then Backup/Restore. (if the right menu is not open click the gear icon in the far right corner of the screen)
The Backup section pictured below contains all of the important data tables in the database available for download. You can choose what files you want to download by checking them. Clicking the “Backup” button will download the selected tables in .sql format to your computer. Take note of where this file is saved on your computer to access it easily down the road if you need to do a restore.
RESTORE YOUR STORE DATABASE
To restore your store from a previously saved backup file that you saved to your computer, all you need to do is click “Choose File” from Restore Backup, select the .sql file on your computer, click restore and the database will be restored.
You should backup your store database at least once a month and more often if you make changes to your store often. (for example weekly product additions)