Part II Using MySQL Enterprise Backup

Table of Contents

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 a Back Up of In-Memory Database Data
3.3.7 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 from a Hot Backup
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 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 Troubleshooting for MySQL Enterprise Backup
10.1 Monitoring Backups with MySQL Enterprise Monitor
10.2 Error codes of MySQL Enterprise Backup
10.3 Working Around Corruption Problems
10.4 Using the MySQL Enterprise Backup Logs
10.5 Using the MySQL Enterprise Backup Manifest
11 Frequently Asked Questions for MySQL Enterprise Backup