Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We need to manage automated backup and restoration of multiple websites, most built on PHP / MySQL, hosted on different servers across the globe. All the backups will be made to a single remote server. All servers run on Linux.

I was thinking of rdiff-backup with mysqldumps and replication, but we need to get this up and running quickly, so we require an out-of-the-box solution.

Any suggestions?

share|improve this question

3 Answers 3

for the mysqldumps, use automysqldump : it's very configurable. For the code tree, a cron script doing something like the following:

tar cvf - my_www_dir | ssh user@remotehost "cat > mywwwdump.tar"

I'm using this method for a few servers I administer and it works well.

Tid

share|improve this answer

Here is a good one:
http://www.backup-manager.org/about/

EDIT (I see no one read the about page):

Easy and automatic operation

* 1 configuration file, 5 minutes setup.
* Manually invoke backup process or run daily unattended via CRON.

Comprehensive Backup

* Backup files, MySQL databases and Subversion repositories.
* Specify multiple targets to backup at once (/etc, /home, etc…).
* Ability to exclude files from backup.
* Automatically purge old backups.

Backup Methods

* Full backup only or Full + Incremental backup.
* Backup to an attached disk, LAN or Internet.
* Burns backup to CD/DVD with MD5 checksum verification.
* Archives in lots of open formats: tar, gzip, bzip2, lzma, dar, zip.
* Slice archives to 2 GB if using dar archives format.

Secure

* Backup over SSH.
* Encrypts archives.
* Offsite remote upload of archives via FTP, SSH, RSYNC or Amazon S3.

Advanced

* Can run with different configuration files concurrently.
* Easy external hooks.

Restoration

* Simply uncompressed the open format backup archives with any command line or GUI tool.
share|improve this answer

what are your concerns about rdiff-backup? I've been using it successfully to backup web-sites and MySQL databases (database dumps) for the past year and a half with not real issues. The incremental backups work beautifully and the restore process have saved my neck twice.

Good luck!

share|improve this answer

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.