When you are responsible for your customers' web site and databases you need a flexible backup software. I have my own web hosting provider which I use for some customers’ but others may want or already have a hosting provider that they want to use. You may need a different backup strategy for each hosting provider but I wanted to use one solution for all. For instance I have a post How To Automatically Backup MySQL Database using Cron Job on Go Daddy Linux Shared Hosting that explains how to use a Cron job to backup a Mysql database on Go Daddy. But the Cron job only backs up the database to the local hosting provider folder so you need a way to also transfer the database backups offsite for disaster recovery.
I evaluated several software applications in no particular order (Second Copy, AJC software, Autobackup, Duplicati, Freefilesync, GFI free, Goodsync, Mirrorfolder, Syncback, Todo backup, Viceversa, Allbackup, BackupAssist). I’m sure I didn’t list all that I evaluated but here is a link http://en.wikipedia.org/wiki/Comparison_of_file_synchronization_software that I started with. I’m not going to go into each product since I was looking for specific criteria for myself and if the software didn’t meet my criteria I moved on.
I was looking for a backup sync solution that would meet the following criteria:
- Inexpensive or free
- Sync of my desktop XAMPP folder to my laptop XAMPP folder
- I don’t need this anymore since I now have a laptop that has replaced the desktop and supports multiple monitors)
- Support multiple file versions (don’t need Subversion, CVS or Git)
- Date and time stamp of local files must be transferred over to destination
- Flexible methods for backup but at the least I need ftp, sftp and windows shared folders
- Run as a windows service either logged in or logged out of computer
- Flexible schedule for backup / sync minutes, hourly, daily, weekly and monthly
- Support Windows Volume Shadow Copy VSS for backing up files I have open during development