MySQL Backup and Recovery

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.

• 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 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 Man pages Presentations/White papers Zmanda Recovery Manager for MySQL, Jan 17, 2007 ZRM for MySQL: Vision and Roadmap, MySQL Users Conference, April 25, 2007 MySQL ZRM how-to document for debian sarge distribution MySQL ZRM download info for debian sarge package for 1.0.3 version White paper on installing, configuring, backing up and restoring MySQL database in 15 minutes using ZRM for MySQL. What to consider when you back up a remote MySQL server over internet Top 5 Considerations while setting up your MySQL Backup Comparison of MySQL database backup methods Websites Zmanda Recovery Manager for MySQL home page Forums Subscribe to ZRM mailing lists ZRM users mailing list archive ZRM for MySQL Bugzilla Zmanda Recovery Manager copyright and license About this Wiki Licenses, Copyrights and Trademarks

Releases Release 1.2.1 (Sept, 14, '07) Source tar ball (including debian package files) Help from ZRM online sites Release 1.2 (June, 25 '07) Code restructured into modules. Snapshot plugin interface. LVM snapshots implemented as a plugin. ZRM should be run as n user belonging to the mysql group. Release 1.1.5 (March, 12 '07) New restore options: --mysql-shutdown and --no-mysql-shutdown Do automatic report generation only if html-report-dir is specified. Release 1.1.4 (January 30, '07) Support for aborting backup runs Support for character sets and stored routines Release 1.1.3 (December 19, '06) Support for Ubuntu and MySQL enterprise server Configuration parameters read by the custom plugins Release 1.1.2 (November 21, '06) Debian packaging Support for MySQL 4.0.24 Release 1.1.1 (November 2, '06) FHS compliance Release 1.1 (October 18, '06) Backup compression and encryption Custom plugins to tailor backups to user environment Backup reports as RSS feeds Automatic backup report generation after every backup run Release 1.0.3 (September 22, '06) HTML reports Release 1.0.2 (September 14, '06) Verification of backup images Predefined backup reports and report formatting Tools for selective restoration of database Release 1.0.1 (September 07, '06) Support for backup retention policy Additional backup performance parameters - read-locks-time, flush-logs-time for comparing backup performance between backup runs and backup methods. Release 1.0 (August 31, '06) Initial release with support for MySQL server backup, recovery, scheduling and reporting.