Skip to Main Content
MySQL Enterprise Backup User's Guide (Version 4.1.4)
Previous
What's New in MySQL Enterprise Backup 4.1?
Home
MySQL Enterprise Backup User's Guide (Version 4.1.4)
Next
Backing Up a Database Server
Part II Using MySQL Enterprise Backup
4 Backing Up a Database Server
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)
5 Recovering or Restoring a Database
5.1 Performing a Restore Operation
5.1.1 Restoring a Compressed Backup
5.1.2 Restoring an Encrypted Backup Image
5.1.3 Restoring an Incremental Backup
5.1.4 Restoring Backups Created with the
--use-tts
Option
5.1.5 Restoring a Backup from Cloud Storage to a MySQL Server
5.1.6 Restoring External InnoDB Tablespaces to Different Locations
5.1.7 Advanced: Preparing and Restoring a Directory Backup
5.2 Point-in-Time Recovery
5.3 Restoring a Backup with a Database Upgrade or Downgrade
6 Working with Encrypted InnoDB Tables
7 Using MySQL Enterprise Backup with Replication
7.1 Setting Up a New Replica
7.2 Backing up and Restoring a Replica Database
7.3 Restoring a Source Database
8 Using MySQL Enterprise Backup with Group Replication
9 Encryption for Backups
10 Using MySQL Enterprise Backup with Media Management Software (MMS) Products
10.1 Backing Up to Tape with Oracle Secure Backup
11 Performance Considerations for MySQL Enterprise Backup
11.1 Optimizing Backup Performance
11.2 Optimizing Restore Performance
12 Monitoring Backups with MySQL Enterprise Monitor
13 Troubleshooting for MySQL Enterprise Backup
13.1 Exit codes of MySQL Enterprise Backup
13.2 Working Around Corruption Problems
13.3 Using the MySQL Enterprise Backup Logs
13.4 Using the MySQL Enterprise Backup Manifest
Previous
What's New in MySQL Enterprise Backup 4.1?
Home
MySQL Enterprise Backup User's Guide (Version 4.1.4)
Next
Backing Up a Database Server