- MySQL Enterprise Backup User's Guide (Version 3.6.1)
- Preface and Legal Notice
- I Getting Started with MySQL Enterprise Backup
- 1 Introduction to MySQL Enterprise Backup
- 2 Installing MySQL Enterprise Backup
- II Using MySQL Enterprise Backup
- 3 Backing Up a Database Server
- 4 mysqlbackup Command Reference
- 5 Recovering or Restoring a Database
- 6 Troubleshooting for MySQL Enterprise Backup
- III Appendixes
- A MySQL Enterprise Backup Limitations
- B Compatibility Information for MySQL Enterprise Backup Releases and InnoDB Hot Backup
- C Extended Examples
- D MySQL Enterprise Backup Change History
- E Licenses for Third-Party Components
- Index
Abstract
This is the User's Guide for the MySQL Enterprise Backup product, the successor to the InnoDB Hot Backup product. This manual describes the procedures to back up and restore MySQL databases. It covers techniques for minimizing time and storage overhead during backups, and to keep the database available during backup operations. It illustrates the features and syntax of the mysqlbackup command;, for example, how to back up selected databases or tables, how to back up only the changes since a previous backup, and how to transfer the backup data efficiently to a different server.
The 3.6 release contains major new features and changes to command syntax. If you were a user of MySQL Enterprise Backup 3.5, see Appendix B, Compatibility Information for MySQL Enterprise Backup Releases and InnoDB Hot Backup and Section D.2, “Changes in MySQL Enterprise Backup 3.6.0 (2011-07-01)” for information about the changes.
For legal information, see the Legal Notices.
Document generated on: 2013-06-18 (revision: 3491)
Table of Contents [+/-]
- Preface and Legal Notice
- I. Getting Started with MySQL Enterprise Backup [+/-]
- II. Using MySQL Enterprise Backup [+/-]
- 3. Backing Up a Database Server [+/-]
- 4. mysqlbackup Command Reference [+/-]
- 4.1. mysqlbackup Command-Line Options [+/-]
- 4.1.1. Subcommands
- 4.1.2. Standard Options
- 4.1.3. Connection Options
- 4.1.4. Server Repository Options
- 4.1.5. Backup Repository Options
- 4.1.6. Metadata Options
- 4.1.7. Compression Options
- 4.1.8. Incremental Backup Options
- 4.1.9. Partial Backup Options
- 4.1.10. Single-File Backup Options
- 4.1.11. Capacity Options
- 4.1.12. Options for Special Backup Types
- 4.2. Configuration Files and Parameters [+/-]
- 5. Recovering or Restoring a Database [+/-]
- 6. Troubleshooting for MySQL Enterprise Backup [+/-]
- III. Appendixes [+/-]
- A. MySQL Enterprise Backup Limitations [+/-]
- B. Compatibility Information for MySQL Enterprise Backup Releases and InnoDB Hot Backup [+/-]
- B.1. Compatibility with Older MySQL or InnoDB Versions
- B.2. Compatibility of Backup Data with Other MySQL Enterprise Backup Versions
- B.3. Expanded Use of Configuration Files
- B.4. Relative and Absolute Paths
- B.5. New and Changed Options in MySQL Enterprise Backup 3.6
- B.6. Comparison of MySQL Enterprise Backup and InnoDB Hot Backup
- B.7. ibbackup and innobackup Commands
- C. Extended Examples [+/-]
- D. MySQL Enterprise Backup Change History [+/-]
- E. Licenses for Third-Party Components [+/-]
- MySQL Enterprise Backup Glossary
- Index
List of Tables [+/-]
List of Examples [+/-]
- 3.1. Making an Uncompressed Backup of InnoDB Tables
- 3.2. Making an Uncompressed Partial Backup of InnoDB Tables
- 3.3. Making a Compressed Partial Backup
- 3.4. Single-File Backup to Absolute Path
- 3.5. Single-File Backup to Relative Path
- 3.6. Single-File Backup to Standard Output
- 3.7. Convert Existing Backup Directory to Single Image
- 3.8. Extract Existing Image to Backup Directory
- 3.9. List Single-File Backup Contents
- 3.10. Extract Single-File Backup into Current Directory
- 3.11. Extract Single-File Backup into a Backup Directory
- 3.12. Selective Extract of Single File
- 3.13. Selective Extract of Single Directory
- 3.14. Dealing with Absolute Path Names
- 3.15. Single-File Backup to a Remote Host
- 3.16. Sample mysqlbackup Commands Using MySQL Enterprise Backup with Oracle Secure Backup
- 4.1. Simple Backup with Connection Parameters from Default Configuration File
- 4.2. Basic Incremental Backup
- 4.3. Apply Log to Full Backup
- 4.4. Incremental Backup
- 4.5. Example
backup-my.cnffile - 5.1. Applying the Log to a Backup
- 5.2. Applying the Log to a Compressed Backup
- 5.3. Applying an Incremental Backup to a Full Backup
- 5.4. Shutting Down and Restoring a Database
- 5.5. Steps to Back Up on MySQL 5.1 and Restore on MySQL 5.5
- B.1. Simple Backup Emulating ibbackup Behavior
