Abstract
This is the User's Guide for the MySQL Enterprise 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.
For notes detailing the changes in each release, see the MySQL Enterprise Backup 3.11 Release Notes.
For legal information, see the Legal Notices.
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.
Licensing information. This product may include third-party software, used under license. See the MySQL Enterprise Backup 3.11 License Information User Manual for licensing information, including licensing information relating to third-party software that may be included in this MySQL Enterprise Backup release.
Document generated on: 2021-01-21 (revision: 8265)
Table of Contents
- Preface and Legal Notices
- I Getting Started with MySQL Enterprise Backup
- II Using MySQL Enterprise Backup
- 3 Backing Up a Database Server
- 4 Recovering or Restoring a Database
- 5 mysqlbackup Command Reference
- 5.1 mysqlbackup Command-Line Options
- 5.1.1 Subcommands
- 5.1.2 Standard Options
- 5.1.3 Connection Options
- 5.1.4 Server Repository Options
- 5.1.5 Backup Repository Options
- 5.1.6 Metadata Options
- 5.1.7 Compression Options
- 5.1.8 Incremental Backup Options
- 5.1.9 Partial Backup and Restore Options
- 5.1.10 Single-File Backup Options
- 5.1.11 Performance / Scalability / Capacity Options
- 5.1.12 Message Logging Options
- 5.1.13 Progress Report Options
- 5.1.14 Encryption Options
- 5.1.15 Cloud Storage Options
- 5.1.16 Options for Special Backup Types
- 5.2 Configuration Files and Parameters
- 6 Using MySQL Enterprise Backup with Replication
- 7 Performance Considerations for MySQL Enterprise Backup
- 8 Encryption for Backups
- 9 Using MySQL Enterprise Backup with Media Management Software (MMS) Products
- 10 Monitoring Backups with MySQL Enterprise Monitor
- 11 Troubleshooting for MySQL Enterprise Backup
- 12 Frequently Asked Questions for MySQL Enterprise Backup
- III Appendixes
- Index
List of Tables
List of Examples
- 3.1 Making an Uncompressed Partial Backup of InnoDB Tables
- 3.2 Making a Compressed Partial Backup
- 3.3 Single-File Backup to Absolute Path
- 3.4 Single-File Backup to Relative Path
- 3.5 Single-File Backup to Standard Output
- 3.6 Convert Existing Backup Directory to Single Image
- 3.7 Extract Existing Image to Backup Directory
- 3.8 List Single-File Backup Contents
- 3.9 Extract Single-File Backup into Current Directory
- 3.10 Extract Single-File Backup into a Backup Directory
- 3.11 Selective Extract of Single File
- 3.12 Selective Extract of Single Directory
- 3.13 Dealing with Absolute Path Names
- 3.14 Single-File Backup to a Remote Host
- 3.15 Single-file Backup to a Remote MySQL Server
- 3.16 Stream a Backup Directory to a Remote MySQL Server
- 3.17 Creating a Cloud Backup
- 3.18 Extract an Existing Image from Cloud Storage to Backup Directory
- 3.19 Optimistic Backup Using the Option
optimistic-time=
YYMMDDHHMMSS
- 3.20 Optimistic Backup Using the Option
optimistic-time=now
- 3.21 Optimistic Backup Using the
optimistic-busy-tables
Option - 3.22 Optimistic and Partial Backup Using both the
optimistic-busy-tables
andoptimistic-time
Options - 4.1 Applying the Log to a Backup
- 4.2 Applying the Log to a Compressed Backup
- 4.3 Applying an Incremental Backup to a Full Backup
- 4.4 Shutting Down and Restoring a Database
- 4.5 Restoring a Compressed Backup
- 4.6 Restoring an Encrypted Backup Image
- 4.7 Restoring an Incremental Backup Image
- 4.8 Restoring Selected Tables from a TTS Backup
- 4.9 Restoring a Single-file Backup from Cloud Storage to a MySQL Server
- 5.1 Simple Backup with Connection Parameters from Default Configuration File
- 5.2 Basic Incremental Backup
- 5.3 Apply Log to Full Backup
- 5.4 Incremental Backup
- 5.5 Example
backup-my.cnf
file - 9.1 Sample mysqlbackup Commands Using MySQL Enterprise Backup with Oracle Secure Backup