Chapter 4 Backing Up a Database Server

Table of Contents

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

This section explains the preparations you need for creating backups with MySQL Enterprise Backup, the typical backup-verify-restore cycle, and the different backup scenarios for using MySQL Enterprise Backup. It also includes sample commands and outputs, showing you how to use the mysqlbackup client in different situations.