MySQL Enterprise Backup User's Guide (Version 3.5.4)

Abstract

This is the User's Guide for the MySQL Enterprise Backup product, the successor to the InnoDB Hot Backup product.

For legal information, see the Legal Notices.

Document generated on: 2014-10-13 (revision: 5163)


Table of Contents

Preface and Legal Notices
1 Introduction to MySQL Enterprise Backup
1.1 Hot Backups
1.2 Backup Commands
1.3 Performance and Space Considerations
1.4 Files that Are Backed Up
1.5 Comparison of MySQL Enterprise Backup and InnoDB Hot Backup
2 Installing MySQL Enterprise Backup
3 ibbackup Command Reference
3.1 Options Files
3.2 ibbackup Command-Line Options
4 Making a Backup
4.1 Example: Making an Uncompressed Backup of InnoDB Tables
4.2 Example: Making a Compressed Backup of InnoDB Tables
4.3 Example: Making an Incremental Backup of InnoDB Tables
4.4 Making a Point-in-Time Backup of InnoDB, MyISAM, and Other Tables
5 Preparing the Backup to be Restored
5.1 Example: Applying the Log to a Backup
5.2 Example: Applying the Log to a Compressed Backup
5.3 Example: Applying an Incremental Backup to a Full Backup
5.4 Starting mysqld on a Restored Backup
6 Recovering or Restoring a Database
6.1 Point-in-Time Recovery from a Hot Backup
6.2 Setting Up a New Slave from a Hot Backup in Replication
6.3 Restoring a Master Database in Replication
7 mysqlbackup Command Reference
7.1 mysqlbackup Command-Line Options
7.2 Example: Backing Up InnoDB and MyISAM Tables
7.3 Example: Verifying a Backup
7.4 Example: Restoring a Database at its Original Location
7.5 Specifying MySQL Connection Settings for mysqlbackup
7.6 Example: Setting MySQL Privileges for mysqlbackup
7.7 Example: Making an Incremental Backup of InnoDB and MyISAM tables
8 Making a Partial Backup
8.1 Example: Making an Uncompressed Partial Backup
8.2 Example: Making a Compressed Partial Backup
8.3 Restoring a Single .ibd File
8.4 Backing Up Selected Databases
8.5 Backing Up Files from Different Storage Engines
8.6 Backing Up In-Memory Database Data
9 Troubleshooting for MySQL Enterprise Backup
9.1 Error codes of MySQL Enterprise Backup
9.2 Working Around Corruption Problems
9.3 Using the MySQL Enterprise Backup Backup Logs
A Known Bugs and Limitations
A.1 Limitations of mysqlbackup and ibbackup Commands
A.2 Linux-2.4.18 kernel/driver Bugs
A.3 Known ibbackup and mysqlbackup Bugs
A.4 MySQL Bugs Affecting mysqlbackup
A.5 Compatibility with Older MySQL/InnoDB Versions
B MySQL Enterprise Backup Change History
B.1 Changes in MySQL Enterprise Backup 3.5.4 (2011-04-21)
B.2 Changes in MySQL Enterprise Backup 3.5.2 (2010-12-16)
B.3 Changes in MySQL Enterprise Backup 3.5.1 (2010-11-01)
C Licenses for Third-Party Components
C.1 RegEX-Spencer Library License
C.2 zlib License
C.3 Percona Multiple I/O Threads Patch License
C.4 Google SMP Patch License
C.5 Google Controlling Master Thread I/O Rate Patch License
C.6 RFC 3174 - US Secure Hash Algorithm 1 (SHA1) License
MySQL Enterprise Backup Glossary
Index