MySQL Enterprise Backup User's Guide (Version 8.0.13)

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 8.0 Release Notes.

For legal information, including licensing information, see the Preface and Legal Notices.

For help with using MySQL, please visit either the MySQL Forums or MySQL Mailing Lists, where you can discuss your issues with other MySQL users.

Document generated on: 2018-12-16 (revision: 7648)


Table of Contents     [+/-]

Preface and Legal Notices
I Getting Started with MySQL Enterprise Backup     [+/-]
1 Introduction to MySQL Enterprise Backup     [+/-]
1.1 The mysqlbackup Client
1.2 Overview of Backup Types
1.3 Files that Are Backed Up     [+/-]
1.3.1 Types of Files Contained in a Backup
1.3.2 Files Backed up for InnoDB Data
1.3.3 Files Backed up for Data Stored with MyISAM and Other Storage Engines
1.3.4 Files Generated by mysqlbackup
2 Installing MySQL Enterprise Backup
3 What's New in MySQL Enterprise Backup 8.0?
II Using MySQL Enterprise Backup     [+/-]
4 Backing Up a Database Server     [+/-]
4.1 Before the First Backup     [+/-]
4.1.1 Collect Database Information
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 Backing Up an Entire MySQL Instance
4.2.2 Verifying a Backup
4.2.3 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 Advanced: Preparing and Restoring a Directory Backup
5.2 Point-in-Time Recovery from a Hot Backup
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 Replication Slave
7.2 Backing up and Restoring a Slave Database
7.3 Restoring a Master 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 Using MySQL Enterprise Backup with Docker
12 Performance Considerations for MySQL Enterprise Backup     [+/-]
12.1 Optimizing Backup Performance
12.2 Optimizing Restore Performance
13 Monitoring Backups with MySQL Enterprise Monitor
14 Troubleshooting for MySQL Enterprise Backup     [+/-]
14.1 Exit codes of MySQL Enterprise Backup
14.2 Working Around Corruption Problems
14.3 Using the MySQL Enterprise Backup Logs
14.4 Using the MySQL Enterprise Backup Manifest
III mysqlbackup Command Reference     [+/-]
15 mysqlbackup
16 mysqlbackup commands     [+/-]
16.1 Backup Operations
16.2 Update Operations
16.3 Restore Operations
16.4 Validation Operations
16.5 Other Single-File Backup Operations
16.6 Other Operations
17 mysqlbackup Command-Line Options     [+/-]
17.1 Standard Options
17.2 Connection Options
17.3 Server Repository Options
17.4 Backup Repository Options
17.5 Metadata Options
17.6 Compression Options
17.7 Incremental Backup Options
17.8 Partial Backup and Restore Options
17.9 Single-File Backup Options
17.10 Performance / Scalability / Capacity Options
17.11 Message Logging Options
17.12 Progress Report Options
17.13 Encryption Options
17.14 Options for Working with Encrypted InnoDB Tablespaces
17.15 Cloud Storage Options
17.16 Options for Special Backup Types
17.17 Other Options
18 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 Cross-Platform Compatibility
C.2 Compatibility with MySQL Versions
C.3 Compatibility with Older MySQL Enterprise Backup
D Backup History Table Update
MySQL Enterprise Backup Glossary
Index

List of Examples   [+/-]