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