Part II Using MySQL Enterprise Backup

Table of Contents

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

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

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 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 Performance Considerations for MySQL Enterprise Backup

10.1 Optimizing Backup Performance

10.2 Optimizing Restore Performance

11 Monitoring Backups with MySQL Enterprise Monitor

12 Troubleshooting for MySQL Enterprise Backup

12.1 Error codes of MySQL Enterprise Backup

12.2 Working Around Corruption Problems

12.3 Using the MySQL Enterprise Backup Logs

12.4 Using the MySQL Enterprise Backup Manifest