Difference between revisions of "MySQL Backup and Recovery"

From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search
Line 28: Line 28:
 
* [http://www.zmanda.com/quick-mysql-backup.html White paper] on installing, configuring, backing up and restoring MySQL database in 15 minutes using ZRM for MySQL.
 
* [http://www.zmanda.com/quick-mysql-backup.html White paper] on installing, configuring, backing up and restoring MySQL database in 15 minutes using ZRM for MySQL.
 
* [http://www.zmanda.com/zrm-over-internet.html What to consider when you back up a remote MySQL server over internet]
 
* [http://www.zmanda.com/zrm-over-internet.html What to consider when you back up a remote MySQL server over internet]
 +
* [http://www.zmanda.com/mysql-backup-considerations.html Top 5 Considerations while setting up your MySQL Backup]
  
 
== Releases ==
 
== Releases ==

Revision as of 21:55, 23 August 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