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 Capacity Options
4.1.12 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 Setting Up a New Replication Slave
5.5 Restoring a Master Database in Replication
5.6 Restoring a Single .ibd File
5.7 Restoring a Backup to a Different Database Version
6 Troubleshooting for MySQL Enterprise Backup
6.1 Monitoring Backups with MySQL Enterprise Monitor
6.2 Error codes of MySQL Enterprise Backup
6.3 Working Around Corruption Problems
6.4 Using the MySQL Enterprise Backup Logs
6.5 Using the MySQL Enterprise Backup Manifest