Documentation Home
MySQL Enterprise Backup 3.11 User's Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.0Mb
PDF (A4) - 1.0Mb
HTML Download (TGZ) - 162.0Kb
HTML Download (Zip) - 183.3Kb


MySQL Enterprise Backup User's Guide (Version 3.11.1)

Abstract

This is the User's Guide for the MySQL Enterprise Backup product. This manual describes the procedures to back up and restore MySQL databases. It covers techniques for minimizing time and storage overhead during backups, and to keep the database available during backup operations. It illustrates the features and syntax of the mysqlbackup command, for example, how to back up selected databases or tables, how to back up only the changes since a previous backup, and how to transfer the backup data efficiently to a different server.

For notes detailing the changes in each release, see the MySQL Enterprise Backup 3.11 Release Notes.

For legal information, see the 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.

Licensing information.  This product may include third-party software, used under license. See the MySQL Enterprise Backup 3.11 License Information User Manual for licensing information, including licensing information relating to third-party software that may be included in this MySQL Enterprise Backup release.

Document generated on: 2019-02-22 (revision: 7703)


Table of Contents     [+/-]

Preface and Legal Notices
I Getting Started with MySQL Enterprise Backup     [+/-]
1 Introduction to MySQL Enterprise Backup     [+/-]
1.1 Types of Backups
1.2 The mysqlbackup Command
1.3 Overview of Backup Performance and Capacity Considerations
1.4 Files that Are Backed Up
1.5 Overview of Restoring a Database
2 Installing MySQL Enterprise Backup
II Using MySQL Enterprise Backup     [+/-]
3 Backing Up a Database Server     [+/-]
3.1 Before the First Backup     [+/-]
3.1.1 Collect Database Information
3.1.2 Grant MySQL Privileges to Backup Administrator
3.1.3 Designate a Location for Backup Data
3.2 The Typical Backup / Verify / Restore Cycle     [+/-]
3.2.1 Backing Up an Entire MySQL Instance
3.2.2 Verifying a Backup
3.2.3 Restoring a Database at its Original Location
3.3 Backup Scenarios and Examples     [+/-]
3.3.1 Making a Full Backup
3.3.2 Making an Incremental Backup
3.3.3 Making a Compressed Backup
3.3.4 Making a Partial Backup
3.3.5 Making a Single-File Backup
3.3.6 Making an Optimistic Backup
3.3.7 Making a Back Up of In-Memory Database Data
3.3.8 Making Scheduled Backups
4 Recovering or Restoring a Database     [+/-]
4.1 Preparing the Backup to be Restored
4.2 Performing a Restore Operation
4.3 Point-in-Time Recovery
4.4 Backing Up and Restoring a Single .ibd File
4.5 Restoring a Backup with a Database Upgrade or Downgrade
5 mysqlbackup Command Reference     [+/-]
5.1 mysqlbackup Command-Line Options     [+/-]
5.1.1 Subcommands
5.1.2 Standard Options
5.1.3 Connection Options
5.1.4 Server Repository Options
5.1.5 Backup Repository Options
5.1.6 Metadata Options
5.1.7 Compression Options
5.1.8 Incremental Backup Options
5.1.9 Partial Backup and Restore Options
5.1.10 Single-File Backup Options
5.1.11 Performance / Scalability / Capacity Options
5.1.12 Message Logging Options
5.1.13 Progress Report Options
5.1.14 Encryption Options
5.1.15 Cloud Storage Options
5.1.16 Options for Special Backup Types
5.2 Configuration Files and Parameters
6 Using MySQL Enterprise Backup with Replication     [+/-]
6.1 Setting Up a New Replication Slave
6.2 Backing up and Restoring a Slave Database
6.3 Restoring a Master Database
7 Performance Considerations for MySQL Enterprise Backup     [+/-]
7.1 Optimizing Backup Performance
7.2 Optimizing Restore Performance
8 Encryption for Backups
9 Using MySQL Enterprise Backup with Media Management Software (MMS) Products     [+/-]
9.1 Backing Up to Tape with Oracle Secure Backup
10 Monitoring Backups with MySQL Enterprise Monitor
11 Troubleshooting for MySQL Enterprise Backup     [+/-]
11.1 Error codes of MySQL Enterprise Backup
11.2 Working Around Corruption Problems
11.3 Using the MySQL Enterprise Backup Logs
11.4 Using the MySQL Enterprise Backup Manifest
12 Frequently Asked Questions for MySQL Enterprise Backup
III Appendixes     [+/-]
A MySQL Enterprise Backup Limitations     [+/-]
A.1 Limitations of MySQL Enterprise Backup
B Compatibility Information for MySQL Enterprise Backup     [+/-]
B.1 Cross-Platform Compatibility
B.2 Compatibility with MySQL Versions
B.3 Compatibility with Older Versions of MySQL Enterprise Backup
B.4 Compatibility Notes for Specific MySQL Versions
C Extended Examples     [+/-]
C.1 Sample Directory Structure for Full Backup
C.2 Sample Directory Structure for Compressed Backup
C.3 Sample Directory Structure for Incremental Backup
D MySQL Enterprise Backup Release Notes
MySQL Enterprise Backup Glossary
Index

List of Examples   [+/-]