Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

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!

share|improve this question
    
cPanel backup is covered here: webmasters.stackexchange.com/questions/16475/… Would it be OK for any tool to pull down the data and then push to S3 or do you want it to all happen "in the cloud"? –  paulmorriss Feb 8 '12 at 16:49
    
Thanks for the reply @paulmorriss. (1) I saw that link before I asked my question, but there really wasn't a great answer in that one. (2) I don't have a problem with pulling the data down and they pushing it to S3, but I want it to be an automated process. –  WebDevKev Feb 8 '12 at 20:28
add comment

3 Answers 3

up vote 2 down vote accepted

to backup your schema in MySql you can do:

mysqldump -u root -p [schema-name]  > backup.sql

to backup your files:

tar cvfz site_backup.tar.gz [folder to back-up]

and if you really want to make it automatic - create a shell script that creates daily backups with rotation - and call your script from cron.

share|improve this answer
1  
For small sites this works pretty well. Make sure you have enough free space for your account before running these and gzip the mysqldump output file for speedier ftp transfer. For the automation, winscp can be automated to go retrieve a file and delete it. Have the website do the backups on a cron schedule and then have winscp go look for the results and pull them off. –  Fiasco Labs Mar 4 '12 at 18:01
add comment

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.

share|improve this answer
add comment

Hello there is a PHP script doing what you need : Website 2 Backup It has many features, but the most important for your needs :

  • Backup files and databases
  • Avoid shared web hosting limitations (maximum execution time, limitation of upload size)
  • Backup to Amazon S3
  • Incremental files backup to use less space on storage
  • Automated recovery of files and databases from Amazon S3 without files manipulation.
share|improve this answer
3  
You really should disclose when you are promoting your own software –  John Conde Feb 19 '12 at 21:16
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.