Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I don't have a problem with Zmanda but i wonder if there is any better or popular solutions out there other than doing it by hand.

My requirements are:

  • Online backups
  • The tool should decide to use mysqldump or mysqlhotcopy depending on the database
  • Verify integrity of backups
  • Send status emails
  • Clean old backups (optional)
  • Be able to choose between incremental or full backups (optional)

Replication seems to be the "best way to do backups" but I'm not gonna do that on this project.


locked by HopelessN00b Dec 5 '14 at 12:23

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center.

up vote 1 down vote accepted

I know this does not fully answer your question, but anyway:

  • LVM-based snapshots + rdiff-backup or anything else to make differential backup (it's brutal, it might fail you but tends to work for me)
  • xtrabackup - free & open source from Percona. It's young but promising, and provides ability to run live full and incremental backups of InnoDB.

For all of those, you'll need to put some scripts around. I'm ha appy user of backupninja, which I use as wrapper for my scripts. backupninja will mail you when things fail, will log output of commands etc.

Take a look here as well.

I didn't knew about backupninja, looks like a great tool :) – pablasso May 29 '09 at 17:57

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