2/26/2014

How NOT to Treat Database Backups


database backup

Data are one of the most important aspects of your company. Nothing compares with the sinking feeling when something went wrong and you have lost information or it is completely messed up. When all else fails, you might need your backup.

Backup is a means of ensuring that your data are safe and placed somewhere locally. It is critical for organization of well-being of your shop and building in store owner’s mind the confidence that information is protected, so there will be no losses.

Backups are very important, but still there are some mistakes encountered during their making, restoring and usage. Backup problems are among the most common and time-consuming, so this article provides the list of ill-practices of backup usage for you to avoid them.


1. Failing to Back Up Appropriately

Backups can be different. Some of them are made to save the database structure, other allow to select the information to be copied, the rest make full information listings with all the files and so on. Depending on the purpose, you can make appropriate backup. However, choosing wrong type, from one hand, there is the risk of not backing up your critical data. But on the other hand, if you are doing regular backups full information copies will take long hours and occupy considerably big space at your storage place. Eventually if you do only database structure backup with no data, it is useless to hope that you will be able to restore everything when site crashes.

The way out is to make full backups at least once in a week and before massive changes plus making vital data copies more regular.


2. Restoring wrong copy of your data or outdated backup

If backups are scheduled, usually there are multiple backup jobs for different files running, so there are also multiple data copies saved. Thus, you need to verify if certain backup files contain all the data that needed and they are supposed to contain. This is the way to avoid problems before files are applied to live store.


3. Using backups for wrong purposes

As you know, backups are used for copying store data information and its restoration in case of some faulties. Definitely, it is the means to keep your data safe, however, there are cases when shop managers are too keen on security and use backups as testing area: doing changes locally with backup copy, saving it and restoring over live database... and performing it each time when changes are required. This approach is too time-consuming and not really efficient, since it is possible to do backup before massive changes without the necessity to restore it all the time.


information backup

4. Have only one copy of your data

Multiple backups are critical for good backup strategy or you will have very little time to discover file corruption issues. Thus, it is advisable to make full copies and save them locally and somewhere remotely. Also check with hosting, since they have to regularly do backups. By employing more than one way, you can cover everything while ensuring that data are largely backed up and available.


To sum up, we have discussed the most common problems with backup-related issues. Put together these common sense approaches and work with your online shop in the way to avoid backup troubles and their ill-usages.


By Maria Kvasnytska

No comments:

Post a Comment