MySQL Backup and Recovery

From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search

Zmanda Recovery Manager (ZRM) for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server.

With ZRM for MySQL you can:

  • Schedule full and incremental logical or raw backups of your MySQL database
  • Perform backup that is the best match for your storage engine and your MySQL configuration
  • Get e-mail notification about status of your backups
  • Monitor and obtain reports about your backups (including RSS feeds!!!)
  • Verify your backup images
  • Compress and encrypt your backup images
  • Implement Site or Application specific backup policies
  • Recover database easily to any point in time or to any particular database event
  • Custom plugins to tailor MySQL backups to your environment

Documentation

Presentations

White papers

Releases

Other tools/scripts for MySQL backup

  • mybackup.sh Script for exporting MySQL databases into a compressed file, so you can easily backup them later using amanda or any other kind of backup tool. Also it backups binary logs (if enabled) and configuration files. The script has a small configuration area so you can adapt it to your needs.

Note: You should never backup open database files. You won`t be able to restore them.

Other Links