Chat now with support
Chat with Support

NetVault Backup Plug-in for MySQL 12.2 - User Guide

Introducing NetVault Backup Plug-in for MySQL Installing and removing the plug-in Configuring the plug-in Backing up data Restoring data Working with native MySQL replication Using the plug-in in a Failover Cluster environment Troubleshooting

Renaming a database during a restore

NetVault Backup lets you select a backed-up MySQL database and rename it for a restore so that it does not overwrite the existing version of that database. This process can be useful when creating a copy of an existing database. To accomplish this process, perform the steps outlined in the following topics.

Before conducting a restore rename, review this list of known limitations and intended uses for this operation:

1
In the Navigation pane, click Create Restore Job, select Plug‑in for MySQL from the Plugin Type list, select the applicable saveset, and click Next.
2
On the Create Selection Set page, click the database that you want to rename, and select Rename from the context menu.
3
In the Rename/Relocate dialog box, enter the new name in the Rename to box, and click Ok.

Restoring to a different MySQL Instance on the same server

In this form of relocation restore, a Plug‑in for MySQL backup is to be restored to the same MySQL Server machine, but to a different instance of MySQL that has been configured there.

To accomplish this process, perform the steps outlined in the following topics.

Before conducting a relocation restore, review this list of known limitations and intended uses for this operation:

Prerequisites

The following prerequisites must be met before a restore of this type can be set up and run.

Existing and target machines must have the same Installation configurations: Both machines must have the following established, regarding MySQL:
New target instance must be successfully configured in Plug‑in for MySQL: The process outlined in Configuring the plug-in must have been successfully performed to add the new MySQL Instance; that is, the target instance must be revealed and accessible within the Plug‑in for MySQL node on the NetVault Backup Selections page.

Setting up and starting the restore

With the prerequisites met, perform the following steps to set up this form of relocation restore job.

1
2
On the Create Restore Job — Choose Saveset page, select Plug‑in for MySQL from the Plugin Type list.
When you select a saveset, the following details are displayed in the Saveset Information area: Job ID, job title, server name, client name, plug-in name, saveset date and time, retirement setting, Incremental Backup or not, Archive or not, saveset size, and snapshot-based backup or not.
5
Click Next.
6
On the Create Selection Set page, select the data that you want to restore.
7
With the applicable databases selected, click Edit Plugin Options, and then click the Restore Destination tab.
8
In the Restore Destination Details section, enter the following:
Username: Enter the login account name used to access the target MySQL Instance.
Password: Enter the password associated with the login account.
Instance Name: Enter the NetVault Backup name established for the new instance of MySQL, based on what was established during its configuration in NetVault Backup — this name is the name established as the MySQL Instance Name in the Configure dialog box ; for more information, see Configuring the plug-in.
10
To save the settings, click Ok, and then click Next.
11
In Job Name, specify a name for the job if you do not want to use the default setting.
12
In the Target Client list, select the machine on which you want to restore the data.
TIP: You can also click Choose, and then locate and select the applicable client in the Choose the Target Client dialog box.
13
Use the Schedule, Source Options, and Advanced Options lists to configure any additional required options.
14
Click Save or Save & Submit, whichever is applicable.
You can monitor progress on the Job Status page and view the logs on the View Logs page. For more information, see the Quest NetVault Backup Administrator’s Guide.
Related Documents