抽象的
这是 MySQL Enterprise Backup 的用户手册,MySQL 数据库的商业许可备份实用程序。它解释了可以使用 MySQL Enterprise Backup 执行的不同类型的备份和恢复,并描述了执行它们的命令。还讨论了优化备份和恢复操作的策略。
有关详细说明每个版本中更改的注释,请参阅 MySQL Enterprise Backup 4.1 发行说明。
有关法律信息(包括许可信息),请参阅 前言和法律声明。
如需有关使用 MySQL 的帮助,请访问 MySQL 论坛,您可以在其中与其他 MySQL 用户讨论您的问题。
文档生成于:2022-11-08(修订:8483)
目录
- 前言和法律声明
- 我开始使用 MySQL 企业备份
- 二、使用MySQL企业备份
- 4 备份数据库服务器
- 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从 Oracle Cloud Infrastructure (OCI) 对象存储服务恢复云增量备份到 MySQL 服务器
- 5.12将单文件备份从 OpenStack 对象存储恢复到 MySQL 服务器
- 5.13将单个文件备份从 Amazon S3 恢复到 MySQL 服务器
- 5.14使用copy-back-and-apply-log恢复备份目录
- 5.15将日志应用到备份
- 5.16将日志应用到压缩备份
- 10.1使用 MySQL Enterprise Backup 和 Oracle Secure Backup 的示例mysqlbackup命令
- 15.1将日志应用到全量备份
- 17.1示例
backup-my.cnf
文件