Recover

The below documentation provides detailed step-by-step process for recovering MySQL workload backups using Zmanda Pro's backupmanager.

Prerequisites

  • Successful restore of the selected snapshot and its associated snapshots required to perform recovery.

Steps to Perform Recovery

  1. Initiate the Recovery Command: To start the recovery process, execute the following command on the client machine:

backupmanager mysql recover --pi-name <Protected Item Name>
  1. Select Recovery Type: Choose between a full recovery or full and incremental recovery. For Point-In-Time Recovery (PITR), select the incremental recovery option.

    • Full Recovery: If you select a full recovery, the process will restore your server, database, or table to the point of the latest full backup.

    • Incremental Recovery: If incremental recovery is chosen, you'll be prompted to select either an incremental recovery or a point-in-time recovery.

      • Incremental Recovery: Restores data to the point of the selected incremental backup.

      • Point-In-Time Recovery (PITR): You will be prompted to select a time range from the available snapshots. Example:

        1. Select a time range:

        Start: 2024-10-29 10:59:09, End: 2024-10-29 11:00:23
        Start: 2024-10-29 08:40:57, End: 2024-10-29 10:59:08
        Exit
        1. Select a Binary Log: After selecting a time range, choose a specific binary log file within that time frame for recovery. Example:

        binlog.000284
        Start: 2024-10-29 10:59:09
        End: 2024-10-29 11:00:23
        [BACK]
        1. Select a Commit: Once a binary log is chosen, you can specify the particular commit for restoration based on the queries and timestamps listed. Example:

        Select from queries
        [BACK]
        Select preferred time stamp?
        [BACK]
        ▸ Commit 1 2024 11:00:02
          Commit 2 2024 11:00:04
        --------- Commit Details ----------
        Query 1
        INSERT INTO new.`my_table` SET @1=13 @2='incall'
        Timestamp: 2024-10-29 11:00:02
        1. Initiate Recovery: After selecting the desired timestamp, the recovery process will begin. Once completed, the output will confirm the success of the full and PITR recovery.

        Proceeding with PITR Recovery...
        Starting recovery flow
        Full recovery binlog_file_name: binlog.000284
        Full recovery binlog_file_position: 158
        Full binlog and PITR binlog applied successfully
        Recovery flow completed successfully
        Updating status file as the restore and recovery flow is complete

This process ensures precise control over your MySQL data recovery, allowing you to restore data accurately to the desired point in time.

Last updated

Was this helpful?