Backup and Recovery

From WikiContent

(Difference between revisions)
Jump to: navigation, search
(New page: * Why we make backups * The MySQL Backup feature * Backing up data * Restoring data * Using MySQL Backup and point-in-time recovery * The backup logs)
Line 1: Line 1:
-
* Why we make backups
+
Backup and Recovery
-
* The MySQL Backup feature
+
 
-
* Backing up data
+
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.
-
* Restoring data
+
 
-
* Using MySQL Backup and point-in-time recovery
+
Why we make backups
-
* The backup logs
+
 
 +
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

Revision as of 02:03, 6 January 2010

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