Movatterモバイル変換

Documentation Home

MySQL Enterprise Backup 9.0 User's Guide

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 AccessNetwork (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 themysqlbackup client in different situations.

PREV HOME UP NEXT