MySQL Backup & Recovery Overview

MySQL Backup & Recovery Overview

Overview

BDRShield's MySQL Backup solution provides reliable protection for your MySQL databases, ensuring secure backups of your critical data. With BDRShield, 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 BDRShield's MySQL Backup solution works by watching our demo video.

How to Get Started

Step 1: Download and Install BDRShield Backup Server

  1. Click to Download BDRShield Backup Server here
  1. To Install BDRShield 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  

Need More Information? 

For any questions or additional assistance, feel free to reach out to our support team at: bdr-support@vembu.com


    • Related Articles

    • Does BDRShield provide reports for MySQL Server backup and recovery?

      Yes, BDRShield offers comprehensive reporting for MySQL Server backup and recovery. This includes a dashboard report for an overview of your backup operations, job-level reports for individual backup jobs, restore reports for tracking restoration ...
    • KVM Backup and Recovery

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

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

      Overview BDRShield 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 ...
    • Microsoft 365 Backup & Recovery

      Overview BDRShield provides a complete backup solution for Microsoft 365 and its objects including User Mailbox, Group Mailbox, SharePoint Sites and Teams, ensuring the protection and easy recovery of your data. With flexible storage options and ...