Backup and Recovery

From WikiContent

Revision as of 02:03, 6 January 2010 by Chuck.bell (Talk | contribs)
Jump to: navigation, search

Backup and Recovery

A good maintenance plan for any database system includes a means to preserve the data. The main objective is to archive the data in case of failure or accidental loss. There are many ways you can backup and restore data in MySQL. The two most prominent methods are the MySQL Backup feature and the mysqldump utility. The following sections describe these methods and related backup topics.

Why we make backups

The MySQL Backup Feature

Starting in versions 5.5 and 6.0 betas, MySQL has provided the MySQL Backup feature which is comprised of two SQL commands (BACKUP DATABASE and RESTORE) as well as a command line utility (mysqlbackup).

Backing up data

Restoring data

Using MySQL Backup and point-in-time recovery

The backup logs

Third Party Tools

There are a number of third-party tools that you can use such as the following.

  • Physical file copy
  • Zmanda Recovery Manager
  • Innobase's InnoDB Hot Backup
  • Logical Volume Manager snapshots
Personal tools