Abstract
This is the user manual for MySQL Enterprise Backup, a commercially licensed backup utility for MySQL databases. It explains the different kinds of backup and restore that can be performed with MySQL Enterprise Backup, and describes the commands for performing them. Strategies for optimizing backup and restore operations are also discussed.
For notes detailing the changes in each release, see theMySQL Enterprise Backup 9.0 Release Notes.
For legal information, including licensing information, see thePreface and Legal Notices.
For help with using MySQL, please visit theMySQL Forums, where you can discuss your issues with other MySQL users.
Document generated on: 2025-01-28 (revision: 8692)
Table of Contents
- Preface and Legal Notices
- I Getting Started with MySQL Enterprise Backup
- II Using MySQL Enterprise Backup
- 4 Backing Up a Database Server
- 5 Recovering or Restoring a Database Server
- 5.1 Performing a Restore Operation
- 5.1.1 Restoring a Compressed Backup
- 5.1.2 Restoring an Encrypted Backup Image
- 5.1.3 Restoring an Incremental Backup
- 5.1.4 Table-Level Recovery (TLR)
- 5.1.5 Restoring Backups Created with the
--use-ttsOption - 5.1.6 Restoring External InnoDB Tablespaces to Different Locations
- 5.1.7 Advanced: Preparing and Restoring a Directory Backup
- 5.2 Restoring a Backup from Cloud Storage to a MySQL Server
- 5.3 Point-in-Time Recovery
- 5.4 Restoring a Backup with a Database Server Upgrade or Downgrade
- 6 Working with Encrypted InnoDB Tablespaces
- 7 Backing up Using Redo Log Archiving
- 8 Using MySQL Enterprise Backup with Replication
- 9 Using MySQL Enterprise Backup with Group Replication
- 10 Encryption for Backups
- 11 Using MySQL Enterprise Backup with Media Management Software (MMS) Products
- 12 Using MySQL Enterprise Backup with Docker
- 13 Performance Considerations for MySQL Enterprise Backup
- 14 Monitoring Backups with MySQL Enterprise Monitor
- 15 Using MySQL Enterprise Backup with MySQL Enterprise Firewall
- 16 Using LDAP for Server Authentication
- 17 Troubleshooting for MySQL Enterprise Backup
- IIImysqlbackup Command Reference
- 18mysqlbackup
- 19mysqlbackup commands
- 20mysqlbackup Command-Line Options
- 20.1 General Options
- 20.2 Connection Options
- 20.3 Server Repository Options
- 20.4 Backup Repository Options
- 20.5 Metadata Options
- 20.6 Compression Options
- 20.7 Incremental Backup Options
- 20.8 Partial Backup and Restore Options
- 20.9 Single-File Backup Options
- 20.10 Performance / Scalability / Capacity Options
- 20.11 Message Logging Options
- 20.12 Progress Report Options
- 20.13 Encryption Options
- 20.14 Options for Working with Encrypted InnoDB Tablespaces and EncryptedBinary/Relay Logs
- 20.15 Cloud Storage Options
- 20.16 Options for Special Backup Types
- 21 Configuration Files and Parameters
- IV Appendixes
- Index
List of Tables
List of Examples
- 4.1Single-File Backup to Absolute Path
- 4.2Single-File Backup to Relative Path
- 4.3Single-File Backup to Standard Output
- 4.4Convert Existing Backup Directory to Single Image
- 4.5Extract Existing Image to Backup Directory
- 4.6List Single-File Backup Contents
- 4.7Validate a Single-File Backup
- 4.8Extract Single-File Backup into Current Directory
- 4.9Extract Single-File Backup into a Backup Directory
- 4.10Selective Extract of Single File
- 4.11Selective Extract of Single Directory
- 4.12Dealing with Absolute Path Names
- 4.13Single-File Backup to a Remote Host
- 4.14Single-file Backup to a Remote MySQL Server
- 4.15Stream a Backup Directory to a Remote MySQL Server
- 4.16Creating a Cloud Backup on Oracle Cloud Infrastructure Object Storage
- 4.17Creating a Cloud Incremental Backup on Oracle Cloud Infrastructure
- 4.18Creating a Cloud Backup on an OpenStack Object Storage
- 4.19Creating a Cloud Backup in an Amazon S3 Bucket
- 4.20Creating a Cloud Incremental Backup in an Amazon S3 Bucket
- 4.21Creating a Cloud Backup on GCP Storage Service
- 4.22Making an Uncompressed Partial Backup of InnoDB Tables
- 4.23Making a Compressed Partial Backup
- 4.24Optimistic Backup Using the Option
optimistic-time=YYMMDDHHMMSS - 4.25Optimistic Backup Using the Option
optimistic-time=now - 4.26Optimistic Backup Using the
optimistic-busy-tablesOption - 4.27Optimistic and Partial Backup Using both the
optimistic-busy-tablesandoptimistic-timeOptions - 5.1Restoring a Database Server
- 5.2Restoring a Compressed Backup
- 5.3Restoring a Compressed Directory Backup
- 5.4Restoring a Compressed and Prepared Directory Backup
- 5.5Restoring an Encrypted Backup Image
- 5.6Restoring an Incremental Backup Image
- 5.7Restoring A Selected Table from an Image Backup
- 5.8Restoring Selected Tables in a Schema from an Image Backup
- 5.9Restoring and Renaming a Table from a TTS Backup
- 5.10Restoring a Backup Directory usingcopy-back-and-apply-log
- 5.11Applying the Log to a Backup
- 5.12Restoring a Single-file Backup from an Oracle Cloud Infrastructure (OCI) Object Storage to a MySQL Server
- 5.13Restoring a Cloud Incremental Backup from an Oracle Cloud Infrastructure (OCI) Object Storage to a MySQL Server
- 5.14Restoring a Single-file Backup from an OpenStack Object Storage to a MySQL Server
- 5.15Restoring a Single-file Backup from Amazon S3 to a MySQL Server
- 5.16Restoring a Single-file Backup from GCP Storage Service to a MySQL Server
- 11.1Samplemysqlbackup Commands Using MySQL Enterprise Backup with OracleSecure Backup
- 16.1Backup Using Simple LDAP Authentication
- 16.2TTS Restore Using Simple LDAP Authentication
- 16.3Backup Using SALS-based LDAP Authentication
- 16.4TTS Restore Using SALS-based Authentication
- 19.1Apply Log to Full Backup
- 21.1Sample
backup-my.cnffile