We have several websites at multiple hosting companies (all shared hosts - some using cPanel, others using Plesk) and we're looking for a way to backup all files and MySQL databases for each site. We'd like nightly or more frequent backups and prefer that it is completely automated.
My current plan is to store all the backups on an Amazon S3 account or similar. But I'm not sure what tools are out there to accomplish the collection and transfer of the files and databases. It would be nice if there's a way to do everything through a centralized management system, but that's not an absolute requirement.
Any help or suggestions would be greatly appreciated!
I've a dozen sites on Hostgator Centos shared hosting.
I've written a shell script which I placed in crontab which runs at 3am and backups mysql db of all sites, compresses it and email it to rotating gmail or hotmail account. And weekly or so I take full cpanel backups on my hotfile.com account.
If it isn't Ecommerce or so site then this'd suffice.