Quick Start Guide for MySQL Backup & Recovery

Quick Start Guide for MySQL Backup & Recovery

About MySQL Backup

BDRSuite offers a robust solution for safeguarding MySQL databases with automated incremental backups, secure storage, and granular recovery capabilities. Backups can be stored locally, remotely, or in the cloud, all centrally managed for efficient data protection and recovery.

Getting Started

Step 1: Planning

Required Components:

  1. BDRSuite Backup Server
  2. Google Workspace Account

System Requirements (Backup Server): Windows Server 2012 R2 Core (Standard or Datacenter) & above. To learn more, refer to the System Requirements.

Supported Platform (MySQL Server): MySQL 8.0, MySQL 5.7, MySQL 5.6. To learn more, refer to the Supported Platforms.

Port Configuration: Ensure the necessary ports are configured for communication. To learn more, refer to the Port Configuration.

Step 2: Deploying Backup Server

BDRSuite Backup Server is the central management component for configuring, scheduling, managing backups and recovery across virtual, physical, cloud, and SaaS environments. This server has to be installed and hosted on a dedicated machine.

Installation Options:
  1. BDRSuite Backup Server Installation on Windows
  2. BDRSuite Backup Server Installation on Linux
  3. BDRSuite Backup Server Installation on Docker containers

After installation, access the server via http://<IP Address>:6060 or http://localhost:6060. 

Watch BDRSuite Backup Server Installation on Windows Video.

Configuring MySQL Backup & Recovery

Step 1: Creating a Storage Repository

  1. BDRSuite supports on-premise storage options and remote solutions, including DAS, NAS, SAN. You can navigate to the Infrastructure -> Backup Repository tab choose Block Storage. Refer to Block Storage Repository to learn more.
Watch creating Block Storage Repository video

  1. BDRSuite also supports public cloud services like Amazon S3, Azure Blob, Google Cloud, and S3-compatible platforms such as Wasabi, MinIO, and Backblaze. You can navigate to the Infrastructure -> Backup Repository tab choose Object Storage. Refer to Object Storage Repository to learn more.

Step 2: Adding MySQL Backup Sources

To configure MySQL backups, add the MySQL server as a data source in BDRSuite Backup Server.

  • Navigate to Applications & DBs -> Data Source -> MySQL, click on Add MySQL Server, and provide the required database credentials for integration.

Refer to the Adding MySQL Backup Sources documentation.
Watch the Adding MySQL Server as a Data Source video.



Step 3: Configuring MySQL Backups

Set up and manage MySQL backups by configuring backup jobs within BDRSuite Backup Server.

  • Navigate to Database -> Backup -> Configure Backup -> MySQL.

Steps to Configure MySQL Backup:

  1. Provide a unique name for the backup job and select the repository for storing backups.
  2. Choose the MySQL database(s) to back up.
  3. Set the backup schedule for automated incremental backups.
  4. Define retention policies and review the backup settings.
  5. Save the configuration to initiate the backup as scheduled.

Refer to the MySQL Backup Configuration guide for detailed instructions.

Step 4: Recovering MySQL Backups

Perform recovery operations for MySQL backups using BDRSuite Backup Server.

  • Navigate to Recovery -> Restore Backup Data and select the restore option for the respective MySQL backup job.

MySQL Recovery Steps:

  1. Select the Restore Type (Point-in-time or specific backup).
  2. Choose the Database to restore.
  3. Specify the Restore Location (original or alternate).
  4. Initiate the restore process.

Refer to the MySQL Backup & Recovery documentation for details.

Step 5: Managing MySQL Backups

Manage backup jobs by navigating to Backup -> List Backup Jobs. From here, you can:

  • Edit, suspend, or delete backup jobs.
  • Adjust backup schedules.
  • Monitor job status and generate reports.

Learn more in the Managing Backup Job section.

Step 6: Reporting & Notification

Access the Reports tab to view insights into MySQL backup operations, including summaries, status, and error logs. Configure email notifications to receive updates about backup and recovery activities.

Refer to the Reporting & Notifications guide.

Watch the MySQL backup and Recovery video for more information

Secondary Copy for MySQL Backups

Secondary Copy - Offsite Copy

Offsite Copy page provides instructions on configuring Offsite Copy/DR in BDRSuite Backup Server, where backup data is replicated to a DR server in an offsite location for disaster recovery purposes. It explains how to set up offsite copy jobs for MySQL Server backups, allowing backup data to be stored securely in a remote location, ensuring data availability and business continuity in the event of site failure. To learn more refer to the Secondary Copy - Offsite Copy.

Watch Secondary Copy - Offsite Copy Video.

Purchase & Manage Licenses

Licensing in BDRSuite enables seamless management of Azure Backup, including activation, renewal, and allocation of licenses to ensure uninterrupted backup and recovery operations. For further details, refer to the Purchase & Manage License guide, which provides step-by-step instructions.

Watch the Purchase & Manage License video.


    • Related Articles

    • Quick Start Guide for KVM Backup & Recovery

      About KVM Backup & Replication BDRSuite provides a robust and reliable solution for protecting KVM-based virtual environments. It supports full and incremental backups, flexible scheduling, offsite replication, and centralized management. Whether ...

    • Quick Start Guide for oVirt Backup & Recovery

      About oVirt Backup & Recovery BDRSuite provides agentless, image-level backups for oVirt virtual machines, leveraging Changed Block Tracking (CBT) for efficient incremental backups and supporting automated scheduling. Backup data is secured with ...

    • Quick Start Guide for AWS Backup & Recovery

      About AWS Backup & Recovery BDRSuite offers backups for AWS EC2 instances, utilizing native snapshots for efficient backup and recovery. It supports incremental backups to optimize storage and bandwidth usage, with secure storage options across ...

    • Quick Start Guide for PostgreSQL Backup &Recovery

      About PostgreSQL Backup & Recovery BDRSuite provides comprehensive backup solutions for PostgreSQL databases. Automated backup scheduling ensures regular backups without disrupting database operations, while granular recovery allows for restoring ...

    • Quick Start Guide for Windows Disk Image Backup & Recovery

      About Windows Disk/Image Backup & Recovery BDRSuite offers comprehensive Windows disk image backup, with features like incremental backups with Changed Block Tracking (CBT), application-aware processing and various retention policies. Backup data is ...