MySQL Backup & Recovery Overview

MySQL Backup & Recovery Overview

Overview

BDRSuite's MySQL Backup solution provides reliable protection for your MySQL databases, ensuring secure backups of your critical data. With BDRSuite, you can easily restore your MySQL databases in the event of accidental deletion, data corruption, or system failure, ensuring minimal downtime and data loss.

Supported Version 

MySQL 8.0
MySQL 5.7
MySQL 5.6

Watch the Demo Video

Discover how BDRSuite's MySQL Backup solution works by watching our demo video.

How to Get Started

Step 1: Download and Install BDRSuite Backup Server

  1. Click to Download BDRSuite Backup Server here
  1. To Install BDRSuite Backup Server, watch the Backup Server Installation Video below.

Step 2: Create Backup Repository Configuration 

Configure local or remote storage, including DAS, NAS, SAN, or choose public cloud storage like Azure Blob, S3, Google Cloud, or S3-compatible storage options such as Wasabi or MinIO as your backup storage target.

Step 3: Add MySQL Database as a Data Source  

Navigate to the 'Applications &DBs' tab and select 'Add MySQL Database.' Enter the required connection details, including hostname, port, username, and password. Ensure that the necessary permissions are granted for accessing the MySQL database.
For more detailed instructions, watch the demo video linked below
How to Add MySQL Database Server (Linux) as a Data Source for Backup
How to Add MySQL Database Server (Windows) as a Data Source for Backup

Step 4: Configure Backup for MySQL  

  1. Name your backup job and select the configured backup repository  
  2. Choose specific databases or tables to back up  
  3. Set up backup schedules, retention policies, and encryption options  
  4. Save the backup job
  5. You can monitor backup progress, edit jobs, view reports, check statuses, and manage backup jobs from a centralized dashboard.

Step 5: MySQL Recovery 

  1. Navigate to the 'Recovery - Restore Backup Data' menu  
  2. Select the specific database or table to restore 
  3. Choose the restore point or timestamp for the restore 
  4. Specify the target location for restoration (either the original database or a new one) 
  5. Confirm the details and initiate the restoration process
For more detailed instructions, watch the demo video linked above, which covers the entire Backup & Recovery process.
By following these steps, you’ll ensure your MySQL data is securely backed up and recoverable when needed.

Other Backup Solutions  

Files & Folders Backup for Linux  
Files & Folders Backup for Mac  
VMware VM Backup  
Hyper-V VM Backup  
AWS Backup  
MySQL Backup  

Need More Information? 

For any questions or additional assistance, feel free to reach out to our support team at: bdr-support@vembu.com
This version focuses specifically on **MySQL Backup & Recovery**, detailing the key steps for setting up and managing MySQL database backups.

    • Related Articles

    • MySQL Database Recovery

      Step 1: Choose the backup job data that you want to restore. Navigate to the Recovery tab. All the backed up applications & DBs will be listed. Click on the respective restore icon of the MySQL backup job that you want to recover. Step 2: Choose Host ...
    • Configuring MySQL Database Backup

      Step 1: Adding Basic Job Details Enter the following details; Backup Job Name: Provide any proper name for your backup job. Backup Repository: Select the backup repository type. You can choose either Block Storage or Object Storage. Repository Name: ...
    • PostgreSQL Backup and Recovery

      PostgreSQL Backup - Overview BDRSuite provides comprehensive backups for PostgreSQL databases, offering granular-level recovery options. With flexible and instant recovery features, BDRSuite ensures seamless data restoration and business continuity ...
    • KVM Backup and Recovery

      KVM Backup - Overview BDRSuite offers comprehensive agentless backups for KVM. With multiple recovery options, from instant boot recovery to granular file & folder-level recovery, BDRSuite offers flexible and instant data recoveryensuringbusiness ...
    • VMware Backup and Recovery

      Overview BDRSuite offers agentless backup solutions for VMware ESXi & vCenter. This eliminates the need to install backup agents on each VM. It also provides flexible storage, instant & granular recovery, and centralized management for efficient VM ...