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 Backing Up In-Memory Database Data
4 mysqlbackup Command Reference
4.1 mysqlbackup Command-Line Options
4.1.1 Subcommands
4.1.2 Standard Options
4.1.3 Connection Options
4.1.4 Server Repository Options
4.1.5 Backup Repository Options
4.1.6 Metadata Options
4.1.7 Compression Options
4.1.8 Incremental Backup Options
4.1.9 Partial Backup Options
4.1.10 Single-File Backup Options
4.1.11 Performance / Scalability / Capacity Options
4.1.12 Message Logging Options
4.1.13 Progress Report Options
4.1.14 Options for Special Backup Types
4.2 Configuration Files and Parameters
4.2.1 Source Repository Parameters
4.2.2 Backup Repository Parameters
4.2.3 Other Parameters
5 Recovering or Restoring a Database
5.1 Preparing the Backup to be Restored
5.2 Performing a Restore Operation
5.3 Point-in-Time Recovery from a Hot Backup
5.4 Backing Up and Restoring a Single .ibd File
5.5 Restoring a Backup with a Database Upgrade or Downgrade
6 Using MySQL Enterprise Backup with Replication
6.1 Setting Up a New Replication Slave
6.2 Restoring a Master Database in Replication
7 Performance Considerations for MySQL Enterprise Backup
7.1 Optimizing Backup Performance
7.2 Optimizing Restore Performance
8 Using MySQL Enterprise Backup with Media Management Software (MMS) Products
8.1 Backing Up to Tape with Oracle Secure Backup
9 Troubleshooting for MySQL Enterprise Backup
9.1 Monitoring Backups with MySQL Enterprise Monitor
9.2 Error codes of MySQL Enterprise Backup
9.3 Working Around Corruption Problems
9.4 Using the MySQL Enterprise Backup Logs
9.5 Using the MySQL Enterprise Backup Manifest
10 Frequently Asked Questions for MySQL Enterprise Backup