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 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