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 the MySQL Enterprise Backup 4.1 Release Notes.
For legal information, including licensing information, see the Preface and Legal Notices.
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.
Document generated on: 2024-12-09 (revision: 8665)
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
- 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 Restoring Backups Created with the
--use-tts
Option - 5.1.5 Restoring a Backup from Cloud Storage to a MySQL Server
- 5.1.6 Restoring External InnoDB Tablespaces to Different Locations
- 5.1.7 Advanced: Preparing and Restoring a Directory Backup
- 5.2 Point-in-Time Recovery
- 5.3 Restoring a Backup with a Database Upgrade or Downgrade
- 6 Working with Encrypted InnoDB Tables
- 7 Using MySQL Enterprise Backup with Replication
- 8 Using MySQL Enterprise Backup with Group Replication
- 9 Encryption for Backups
- 10 Using MySQL Enterprise Backup with Media Management Software (MMS) Products
- 11 Performance Considerations for MySQL Enterprise Backup
- 12 Monitoring Backups with MySQL Enterprise Monitor
- 13 Troubleshooting for MySQL Enterprise Backup
- III mysqlbackup Command Reference
- 14 mysqlbackup
- 15 mysqlbackup commands
- 16 mysqlbackup Command-Line Options
- 16.1 Standard Options
- 16.2 Connection Options
- 16.3 Server Repository Options
- 16.4 Backup Repository Options
- 16.5 Metadata Options
- 16.6 Compression Options
- 16.7 Incremental Backup Options
- 16.8 Partial Backup and Restore Options
- 16.9 Single-File Backup Options
- 16.10 Performance / Scalability / Capacity Options
- 16.11 Message Logging Options
- 16.12 Progress Report Options
- 16.13 Encryption Options
- 16.14 Options for Working with Encrypted InnoDB Tablespaces
- 16.15 Cloud Storage Options
- 16.16 Options for Special Backup Types
- 16.17 Other Options
- 17 Configuration Files and Parameters
- IV Appendixes
- Index
List of Tables
List of Examples
- 4.1 Single-File Backup to Absolute Path
- 4.2 Single-File Backup to Relative Path
- 4.3 Single-File Backup to Standard Output
- 4.4 Convert Existing Backup Directory to Single Image
- 4.5 Extract Existing Image to Backup Directory
- 4.6 List Single-File Backup Contents
- 4.7 Validate a Single-File Backup
- 4.8 Extract Single-File Backup into Current Directory
- 4.9 Extract Single-File Backup into a Backup Directory
- 4.10 Selective Extract of Single File
- 4.11 Selective Extract of Single Directory
- 4.12 Dealing with Absolute Path Names
- 4.13 Single-File Backup to a Remote Host
- 4.14 Single-file Backup to a Remote MySQL Server
- 4.15 Stream a Backup Directory to a Remote MySQL Server
- 4.16 Creating a Cloud Backup on Oracle Cloud Infrastructure Object Storage Classic
- 4.17 Creating a Cloud Backup on Oracle Cloud Infrastructure Object Storage
- 4.18 Creating a Cloud Incremental Backup on Oracle Cloud Infrastructure Object Storage
- 4.19 Creating a Cloud Backup on an OpenStack Object Storage
- 4.20 Creating a Cloud Backup on Amazon S3
- 4.21 Extract an Existing Image from an Oracle Cloud Infrastructure Object Storage Classic Container to a Backup Directory
- 4.22 Extract an Existing Image from Amazon S3 Cloud Storage to a Backup Directory
- 4.23 Making an Uncompressed Partial Backup of InnoDB Tables
- 4.24 Making a Compressed Partial Backup
- 4.25 Optimistic Backup Using the Option
optimistic-time=
YYMMDDHHMMSS
- 4.26 Optimistic Backup Using the Option
optimistic-time=now
- 4.27 Optimistic Backup Using the
optimistic-busy-tables
Option - 4.28 Optimistic and Partial Backup Using both the
optimistic-busy-tables
andoptimistic-time
Options - 5.1 Restoring a Database
- 5.2 Restoring a Compressed Backup
- 5.3 Restoring a Compressed Directory Backup
- 5.4 Restoring a Compressed and Prepared Directory Backup
- 5.5 Restoring an Encrypted Backup Image
- 5.6 Restoring an Incremental Backup Image
- 5.7 Restoring Selected Tables from a TTS Image Backup
- 5.8 Restoring and Renaming a Table from a TTS Backup
- 5.9 Restoring a Single-file Backup from an Oracle Cloud Infrastructure (OCI) Object Storage Classic Container to a MySQL Server
- 5.10 Restoring a Single-file Backup from an Oracle Cloud Infrastructure (OCI) Object Storage to a MySQL Server
- 5.11 Restoring a Cloud Incremental Backup from an Oracle Cloud Infrastructure (OCI) Object Storage Service to a MySQL Server
- 5.12 Restoring a Single-file Backup from an OpenStack Object Storage to a MySQL Server
- 5.13 Restoring a Single-file Backup from Amazon S3 to a MySQL Server
- 5.14 Restoring a Backup Directory using copy-back-and-apply-log
- 5.15 Applying the Log to a Backup
- 5.16 Applying the Log to a Compressed Backup
- 10.1 Sample mysqlbackup Commands Using MySQL Enterprise Backup with Oracle Secure Backup
- 15.1 Apply Log to Full Backup
- 17.1 Example
backup-my.cnf
file