MySQL 企业备份用户指南(4.1.5 版)

抽象的

这是 MySQL Enterprise Backup 的用户手册,MySQL 数据库的商业许可备份实用程序。它解释了可以使用 MySQL Enterprise Backup 执行的不同类型的备份和恢复,并描述了执行它们的命令。还讨论了优化备份和恢复操作的策略。

有关详细说明每个版本中更改的注释,请参阅 MySQL Enterprise Backup 4.1 发行说明

有关法律信息(包括许可信息),请参阅 前言和法律声明

如需有关使用 MySQL 的帮助,请访问 MySQL 论坛,您可以在其中与其他 MySQL 用户讨论您的问题。

文档生成于:2022-11-08(修订:8483)


目录

前言和法律声明
我开始使用 MySQL 企业备份
1 MySQL企业备份简介
1.1 mysqlbackup客户端
1.2 备份类型概述
1.3 备份的文件
1.3.1 备份中包含的文件类型
1.3.2 InnoDB数据备份文件
1.3.3 MyISAM等存储引擎存储数据备份文件
1.3.4 mysqlbackup生成的文件
2 安装MySQL企业备份
3 MySQL Enterprise Backup 4.1 有什么新功能?
二、使用MySQL企业备份
4 备份数据库服务器
4.1 第一次备份前
4.1.1 收集数据库信息
4.1.2 Grant MySQL Privileges to Backup Administrator
4.1.3 Designate a Location for the Backup Directory
4.2 The Typical Backup / Verify / Restore Cycle
4.2.1 OS User for Running mysqlbackup
4.2.2 Backing Up an Entire MySQL Instance
4.2.3 Verifying a Backup
4.2.4 Restoring a Database
4.3 Backup Scenarios and Examples
4.3.1 Making a Single-File Backup
4.3.2 Making a Full Backup
4.3.3 Making a Differential or Incremental Backup
4.3.4 Making a Compressed Backup
4.3.5 Making a Partial Backup
4.3.6 Making an Optimistic Backup
4.3.7 Making a Back Up of In-Memory Database Data
4.3.8 Making Scheduled Backups
4.4 Making Backups with a Distributed File System (DFS) or Storage Access Network (SAN)
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
7.1 Setting Up a New Replica
7.2 Backing up and Restoring a Replica Database
7.3 Restoring a Source Database
8 Using MySQL Enterprise Backup with Group Replication
9 Encryption for Backups
10 Using MySQL Enterprise Backup with Media Management Software (MMS) Products
10.1 Backing Up to Tape with Oracle Secure Backup
11 Performance Considerations for MySQL Enterprise Backup
11.1 Optimizing Backup Performance
11.2 Optimizing Restore Performance
12 Monitoring Backups with MySQL Enterprise Monitor
13 Troubleshooting for MySQL Enterprise Backup
13.1 Exit codes of MySQL Enterprise Backup
13.2 Working Around Corruption Problems
13.3 Using the MySQL Enterprise Backup Logs
13.4 Using the MySQL Enterprise Backup Manifest
III mysqlbackup Command Reference
14 mysqlbackup
15 mysqlbackup commands
15.1 Backup Operations
15.2 Update Operations
15.3 Restore Operations
15.4 Validation Operations
15.5 Other Single-File Backup Operations
15.6 Other Operations
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
A Frequently Asked Questions for MySQL Enterprise Backup
B Limitations of MySQL Enterprise Backup
C Compatibility Information for MySQL Enterprise Backup
C.1 Supported Platforms
C.2 Cross-Platform Compatibility
C.3 Compatibility with MySQL Versions
C.4 Compatibility with Older MySQL Enterprise Backup
D Backup History Table Update
MySQL Enterprise Backup Glossary
Index

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 and optimistic-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文件