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

4.2 The Typical Backup / Verify / Restore Cycle

4.2.1 OS User for Running mysqlbackup

4.2.2 Backing Up an Entire MySQL Instance

4.2.3 Verifying a Backup

4.2.4 Restoring a Database

4.3 Backup Scenarios and Examples

4.3.1 Making a Full Backup

4.3.2 Making a Differential or Incremental Backup

4.3.3 Making a Compressed Backup

4.3.4 Making a Partial Backup

4.3.5 Making a Single-File 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 Preparing the Backup to be Restored

5.2 Performing a Restore Operation

5.2.1 Restoring a Compressed Backup

5.2.2 Restoring an Encrypted Backup Image

5.2.3 Restoring an Incremental Backup

5.2.4 Restoring Backups Created with the --use-tts Option

5.2.5 Restoring External InnoDB Tablespaces to Different Locations

5.2.6 Restoring a Backup from Cloud Storage to a MySQL Server

5.3 Point-in-Time Recovery

5.4 Restoring a Backup with a Database Upgrade or Downgrade

6 Using MySQL Enterprise Backup with Replication

6.1 Setting Up a New Replica

6.2 Backing up and Restoring a Replica Database

6.3 Restoring a Source 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