Chapter 3 Backing Up a Database Server

Table of Contents

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

This section describes the different kinds of backups that MySQL Enterprise Backup can create and the techniques for producing them, with examples showing the relevant syntax for the mysqlbackup command. It also includes a full syntax reference for the mysqlbackup command.