Difference between revisions of "MySQL Backup and Recovery"

From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search
Line 15: Line 15:
 
== Documentation ==
 
== Documentation ==
  
* [[Zmanda Recovery Manager for MySQL Users Manual]] - Release 1.1.3-5 and Release 1.2
+
* [[Zmanda Recovery Manager for MySQL Users Manual]] - Release 1.1.3-5 and Release 1.2.X
 
* [[Zmanda Recovery Manager for MySQL]] users manual - Release 1.1.2 and earlier versions
 
* [[Zmanda Recovery Manager for MySQL]] users manual - Release 1.1.2 and earlier versions
 
* [[Zmanda Recovery Manager for MySQL Man pages]]
 
* [[Zmanda Recovery Manager for MySQL Man pages]]
Line 31: Line 31:
  
 
== Releases ==
 
== Releases ==
 +
* [http://www.zmanda.com/download-zrm.php Release 1.2.1 (Sept, 14, '07)]
 +
** Bug fixes
 +
** Source tar ball (including debian package files)
 +
** Help from ZRM online sites
 
* [http://www.zmanda.com/download-zrm.php Release 1.2 (June, 25 '07)]
 
* [http://www.zmanda.com/download-zrm.php Release 1.2 (June, 25 '07)]
 
** Bug fixes
 
** Bug fixes

Revision as of 21:52, 14 September 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