Restore

The following outlines the step-by-step process for restoring MySQL workload backups using Zmanda Pro's backupmanager.

Prerequisites

• Make sure Backup Manager login command is run and configurations are loaded before starting with restore.

• Ensure Zmanda Pro is installed and properly configured on the client machine.

• Backup Manager must be installed on the client machine.

• You must know the Protected Item (PI) name and the Storage Information name used for backups.

• The device on which you are running the restore must be connected to the Zmanda Pro server on which the chosen protected backups exists.

Restores Triggered from the Client machine

If the restore command is exited (either gracefully or forcefully), the inventory may not close properly. As a workaround, you'll need to manually delete all inventory related files after exiting the restore process.

1. Initiate the Restore Command On the client machine, execute the following command in the terminal:

backupmanager mysql restore --pi-name <Protected Item Name>

1. Select the snapshot you wish to restore to: You will be prompted to select the snapshot you wish to restore. For Point-In-Time Recovery, choose an incremental snapshot to restore data to a specific point-in-time. Example:

Use the arrow keys to navigate: ↓ ↑ → ← 
? Select the snapshot you wish to restore to. For Point-In-Time Recovery, select an Incremental snapshot:
▸ 2024-10-29 15:24:09 incremental - (Captured MySQL data between 2024-10-29 11:23:01 UTC and 2024-10-29 11:24:02 UTC)
  2024-10-29 15:23:13 full - (Captured MySQL data between 2024-10-28 14:10:41 UTC and 2024-10-29 11:23:01 UTC)
  Upon selecting a snapshot, the necessary snapshots will automatically begin restoring.

1. Upon selecting a snapshot, the necessary snapshots will automatically begin restoring. Example:

Selected Snapshot: 2024-10-29 15:24:09 incremental (Captured MySQL data between 2024-10-29 11:23:01 UTC and 2024-10-29 11:24:02 UTC)
Restoring snapshots... \
Enqueued task : MySQL restore snapshot 63060
Enqueued task : MySQL restore snapshot 3515e
Enqueued task : MySQL restore snapshot 63533
Initiating restore task for snapshotID: 63060
Initiating restore task for snapshotID: 3515e
Initiating restore task for snapshotID: 63533
Restoring snapshots... |
Completed restore of snapshot : 3515e
Restoring snapshots... /
Completed restore of snapshot : 63533
Completed restore of snapshot : 63060
Restoring snapshots...... Done!

You can choose to proceed with the recovery immediately by selecting "Yes" at the prompt, or defer it to a later time according to your needs.

Restores Triggered from the Server-UI

Follow these steps to schedule and initiate a restore from the Zmanda Pro Server-UI

1. Log onto Zmanda Pro Web Portal

   • Access the Zmanda Pro web portal using your user credentials.

2. Navigate to the Restore Menu

   • Click on the "Restore" section to proceed with the restore process.

3. Restore

   • Select the client device and the storage vault from which you want to restore.

   • Click Next to proceed.

   • Choose the primary protected item you wish to restore, then select View All to display available snapshots.

   • Pick the snapshot you want to restore and click Next to proceed to the final configuration step.

   • Choose Program Input option in the "Restore As" field.

   • Enter the following command in the "command" field:

     /usr/local/bin/backupmanager mysql restore --pi-name <Protected-Item-Name> --program-input

   • From the "Process multiple files using:" field, choose the Archive option and select tar from the dropdown menu.

   • Click Restore to begin the process.