Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version. Compare with Current  |   View Page History

You can restore a MySQL database to an alternate server in your Server Backup Manager by following the instructions below.

Note
MySQL database tables can be restored simultaneously; this is implemented by using multiple threads.

1. Follow the instructions listed on Browse MySQL instances to select a Recovery Point containing the necessary database replication and open the Browse Databases window. 

2. When the Browse Databases window opens, select a database instance in the Database Instance field. You can then browse the database instance by clicking the corresponding > icons. 
3. Select the check box for the database you want to restore and click the Restore Selected button. 
The Restore Databases window displays, where you can define the options for the restore.

4. On the Introduction screen, review the introductory information and click Next to proceed.

5. On the Host screen, select the Restore to Alternate Agent option.

Select the agent you want to restore in the Agent field, enter localhost in the Database Host field, and enter 3306 in the Database Port field. 
Click Next to proceed to the following step.

6. On the Authentication screen, you have two options to specify to connect to the database. Select the Specify Alternate Authentication Credentials option. This allows you to set a username and password different from the default ones. The user must have full administrator-level access to the database instance you are going to restore.

Enter the required credentials in the Username and Password fields and click Next to proceed to the following step.

9. The next screen is "Temporary Instance." When restoring databases, the system needs to create a temporary directory on the target Server for the restore. There are two options for this.

  • Use Default Temp Directory - Creates a directory in an OS-specific default location (C:\Temp for Windows, /tmp for Linux).
  • Specify an Alternate Temp Directory - Allows you to control exactly where the temp directory is created on the Server.

The other fields (Connection Information and Virtuozzo Container ID) can be left unchanged.

Select an option, and click "Next" to proceed to the following step.

10. The following screen is "Data Directory." By default, database configuration retrieved during discovery is used. In some environments, this path doesn't point to the actual location on the filesystem for the data. To remedy this, you can choose to specify the exact path for the data directory. This will ensure that the system can locate the data files for the database during the restore.

Select an option, and click "Next" to proceed to the following step.

11. The next screen is "Base Directory". By default, the system automatically determines where on the filesystem the necessary program files are located. In some environments, the automatic method fails. To remedy this, you can specify the exact path for the base directory.

Select an option, and click "Next" to proceed to the following step.

12. On the last "Restore Summary" screen, the settings you have selected are listed.

13. Once you have verified that the specified settings are correct, click "Restore."

14. The "Details for Database Restore" window will appear. It indicates that the restore process is launched. You can watch the progress in real time.

Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.