Backup and Recovery

From WikiContent

(Difference between revisions)
Jump to: navigation, search
Line 1: Line 1:
-
Backup and Recovery
+
== Introduction ==
-
 
+
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.
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 ==
-
Why we make backups
+
== The MySQL Backup Feature ==
-
 
+
-
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).
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 ==
-
Backing up data
+
== Restoring data ==
-
 
+
== Using MySQL Backup and point-in-time recovery ==
-
Restoring data
+
== The backup logs ==
-
 
+
== Third Party Tools ==
-
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.
There are a number of third-party tools that you can use such as the following.
- 
* Physical file copy
* Physical file copy
* Zmanda Recovery Manager
* Zmanda Recovery Manager
* Innobase's InnoDB Hot Backup
* Innobase's InnoDB Hot Backup
* Logical Volume Manager snapshots
* Logical Volume Manager snapshots

Revision as of 02:08, 6 January 2010

Contents

Introduction

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