Skip to Main Content
The world's most popular open source database
Contact MySQL  | 
Login  |  Register
  • MySQL.com
  • Downloads
  • Documentation
  • Developer Zone
Developer Zone Downloads MySQL.com
Documentation
  • MySQL Server
  • MySQL Enterprise
  • Workbench
  • InnoDB Cluster
  • MySQL NDB Cluster
  • Connectors
  • More
  • MySQL.com
  • Downloads
  • Developer Zone
Section Menu:  

Documentation Home
MySQL Enterprise Backup 9.1 User's Guide
  • Preface and Legal Notices
  • Getting Started with MySQL Enterprise Backup
  • Using MySQL Enterprise Backup
    • Backing Up a Database Server
      • Before the First Backup
        • Collect Database Information
        • Grant MySQL Privileges to Backup Administrator
        • Designate a Location for the Backup Directory
      • The Typical Backup / Verify / Restore Cycle
        • OS User for Running mysqlbackup
        • Backing Up an Entire MySQL Instance
        • Verifying a Backup
        • Restoring a Database
      • Backup Scenarios and Examples
        • Making a Single-File Backup
          • Streaming the Backup Data to Another Device or Server
          • Backing Up to Tape
          • Backing Up to Cloud Storage
        • Making a Full Backup
        • Making a Differential or Incremental Backup
        • Making a Compressed Backup
        • Making a Partial Backup
        • Making an Optimistic Backup
        • Making a Back Up of In-Memory Database Data
        • Making Scheduled Backups
      • Making Backups with a Distributed File System (DFS) or Storage Access Network (SAN)
    • Recovering or Restoring a Database Server
      • Performing a Restore Operation
        • Restoring a Compressed Backup
        • Restoring an Encrypted Backup Image
        • Restoring an Incremental Backup
        • Table-Level Recovery (TLR)
        • Restoring Backups Created with the --use-tts Option
        • Restoring External InnoDB Tablespaces to Different Locations
        • Advanced: Preparing and Restoring a Directory Backup
      • Restoring a Backup from Cloud Storage to a MySQL Server
      • Point-in-Time Recovery
      • Restoring a Backup with a Database Server Upgrade or Downgrade
    • Working with Encrypted InnoDB Tablespaces
    • Backing up Using Redo Log Archiving
    • Using MySQL Enterprise Backup with Replication
      • Setting Up a New replica
      • Backing up and Restoring a Replica Database
      • Restoring a Source Database
      • Working with Encrypted Binary and Relay Logs
    • Using MySQL Enterprise Backup with Group Replication
    • Encryption for Backups
    • Using MySQL Enterprise Backup with Media Management Software (MMS) Products
      • Backing Up to Tape with Oracle Secure Backup
    • Using MySQL Enterprise Backup with Docker
    • Performance Considerations for MySQL Enterprise Backup
      • Optimizing Backup Performance
      • Optimizing Restore Performance
    • Monitoring Backups with MySQL Enterprise Monitor
    • Using MySQL Enterprise Backup with MySQL Enterprise Firewall
    • Using LDAP for Server Authentication
    • Troubleshooting for MySQL Enterprise Backup
      • Exit codes of MySQL Enterprise Backup
      • Working Around Corruption Problems
      • Using the MySQL Enterprise Backup Logs
      • Using the MySQL Enterprise Backup Manifest
  • mysqlbackup Command Reference
  • Appendixes
  • Index
Related Documentation
MySQL Enterprise Backup 9.1 Release Notes
Download this Manual
PDF (US Ltr) - 1.3Mb
PDF (A4) - 1.3Mb


version 9.1
9.3
9.2
9.0
8.4  current
8.0
4.1
MySQL Enterprise Backup 9.1 User's Guide  /  Using MySQL Enterprise Backup  /  Backing Up a Database Server

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.


PREV   HOME   UP   NEXT
Related Documentation
MySQL Enterprise Backup 9.1 Release Notes
Download this Manual
PDF (US Ltr) - 1.3Mb
PDF (A4) - 1.3Mb
Contact MySQL Sales
USA/Canada: +1-866-221-0634   (More Countries »)
  © 2025 Oracle

  • Products
  • HeatWave
  • MySQL Enterprise Edition
  • MySQL Standard Edition
  • MySQL Classic Edition
  • MySQL Cluster CGE
  • MySQL Embedded (OEM/ISV)
  • Services
  • Training
  • Certification
  • Support
  • Downloads
  • MySQL Community Server
  • MySQL NDB Cluster
  • MySQL Shell
  • MySQL Router
  • MySQL Workbench
  • Documentation
  • MySQL Reference Manual
  • MySQL Workbench
  • MySQL NDB Cluster
  • MySQL Connectors
  • Topic Guides
  • About MySQL
  • Contact Us
  • Blogs
  • How to Buy
  • Partners
  • Job Opportunities
  • Site Map
  © 2025 Oracle
Privacy / Do Not Sell My Info | Terms of Use | Trademark Policy |
Cookie Preferences