Recover
Recovery
The below documentation provides a 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 is required to perform recovery
Steps to Recover
Initiate the Recovery Command To start the recovery process, execute the following command on the client machine:
Select Recovery Type Choose between a full recovery or full and incremental recovery. For Point-In-Time Recovery (PITR), select the incremental recovery option.
a. 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
b. 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
Point-In-Time Recovery Steps
Select a time range:
Select a Binary Log After selecting a time range, choose a specific binary log file within that time frame for recovery. Example:
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:
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.
This process ensures precise control over your MariaDB data recovery, allowing you to restore data accurately to the desired point in time.
Last updated
Was this helpful?