MySQL Backup Reference Manual Abstract This document describes how to use the backup and recovery capabilities of MySQL Backup. This document is preliminary. This is a translation of the MySQL Reference Manual that can be found at … The MySQL Reference Manual explains how to use Bitkeeper to get the MySQL source. … Most of the utilities are mentioned in the MySQL Reference Manual. …

Chapter1. Using MySQL Backup MySQL Backupprovides capabilities for backing up and restoring databases. MySQL Backup includes these features: •The BACKUP DATABASE and RESTORE SQL statements provide away to makeacopyofa database or set of databases at a given point intime, and away to restore each database toits state as of that time. •Server options and variables enable configuration of backup and restore operation. •The mysqlbackup program enables inspection of backup image files. A backup operation can include tables for different storage engines and the backup image will still be consistent. That is, you need not care which storage engines you’reusing. BACKUP DATABASE saves the data in a consistent backup image with respect toits”validity point.” The validity point ties the backup to the binary log. Restoring a backup can be combined with use of the binary log to accomplish point- in-time recovery: If the restore operation is done because data loss has occurred after the backup was made (that is, after the validity point), restored databases can be brought up to the time of data loss by executing the data changes in the binary log between the times when the backup was made and when the data loss occurred. A goal of the BACKUP DATABASE and RESTORE statements is to enable other database operations to proceed concurrently, to make it unnecessary to take databasesoffline or prevent clients from accessing them. BACKUP DATABASE must block some operations from occurring (such as dropping tables from a database while it is being backed up), but the attempt is made to keep blocking to a minimum. Generally, blocked operations are those involving Data Definition Language (DDL) statements. RESTORE must do more blocking because it writes database contents rather than just reading them. The following discussion covers these aspects of MySQL Backup: •Howtoobtainand install aversion of MySQLthat includes MySQL Backup capabilities •Quick guide to making backups and restoring them •How the backup and restore operations work •Status reporting and monitoring for backup and restore operations Other parts of this manual provide additional information about MySQL Backup: •For
the syntax of MySQL Backup SQL statements, see Chapter 2, MySQL Backup Statements . •For configuration options and variables, see Chapter 3, MySQL Backup Options and Variables . •The mysql backup program displays information about backup image contents; see Section 4.1, ” mysql backup —Display Backup Information” . •For information about using MySQL Backup and replication together, see Chapter 5, MySQL Backup and Replication . •For restrictions on backup and restore operations, see Chapter 6, Restrictions on MySQL Backup . 1.1. Installing MySQL Backup The capabilities described in this document are currently underdevelopment and are available in the source tree contained in the mysql-6.0-backup BZR repository.

Download MySQL Backup Reference Manual.Pdf