Difference between revisions of "MySQL Backup and Recovery"

From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search
Line 34: Line 34:
 
** Code restructured into modules.
 
** Code restructured into modules.
 
** Snapshot plugin interface. LVM snapshots implemented as a plugin.
 
** Snapshot plugin interface. LVM snapshots implemented as a plugin.
** ZRM should be run as user belonging to mysql group.
+
** ZRM should be run as an user belonging to ''mysql'' group.
: (Migration command available for old backup configuration and images)
 
 
* [http://www.zmanda.com/download-zrm.php Release 1.1.5 (March, 12 '07)]
 
* [http://www.zmanda.com/download-zrm.php Release 1.1.5 (March, 12 '07)]
 
** New restore options: --mysql-shutdown and --no-mysql-shutdown
 
** New restore options: --mysql-shutdown and --no-mysql-shutdown

Revision as of 23:52, 25 June 2007

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