Restoring MySQL Databases to Alternate Locations

Version 23 by Irina Gruzdilovich
on Mar 06, 2012 16:37.

<< Changes from 22 to 23

compared with

Current by Nata Ramanenka
on Apr 11, 2012 10:01.

Key

This line was removed.

This word was removed. This word was added.

This line was added.

Changes (2)

View Page History

...

You can restore a MySQL database to an alternate Agent by following the instructions below in your CDP Enterprise or Advanced Edition.

1. Click on "Recovery Points" in the Main Menu to open the "Recovery Points" window.

!me.png!

2. In the "Recovery Points" list, select a Recovery Point containing the necessary database replication.
{info:title=Tip}To find a Recovery Point, you can use the Basic and Advanced List Filters. See [Customizing the Recovery Points List|http://wiki.r1soft.com/display/CDP3/Customizing+the+Recovery+Points+List].
{info}
Click on the "Browse Databases" icon in the "Actions" column for this Recovery Point.
!m1.png!

3. The "Browse Databases" window opens. Select a database instance from the drop-down menu.
!q1f.png!

4. You can browse the instance by clicking the "+" icon.
!m3f.png!

5. Select the database you want to restore and click "Restore Selected."
{info:title=Note}Starting with CDP version 3.14 and higher you can no longer select to restore individual tables or other objects like triggers or views. You can only restore the entire database.
{info}
!qq2f.png!

6. In the appeared "Restore Databases" wizard window, define the options for the restore.

On the first screen, familiarize yourself with the introductory information and click "Next" to proceed.

!intro.png!

7. On the "Host" screen, you have two options for selecting the host to restore to:
* *Restore to Original Host* \- If you select this option, the restore will be done to the Agent where the source database was located. If the database exists, it can be overwritten.
* *Restore to Alternate Agent* \- Select a destination Agent which is already added to the system.

Select "Restore to Alternate Agent."
!alt1.png!

After that select the Agent from the drop-down menu.
!alt2.png!

The Database Host should be set to *localhost* and the Database Port should be *3306*.
!alt3.png!

Click "Next" to proceed to the following step.
!restore-wizard-next.png!

8. On the "Authentication" screen, you have two options to specify to connect to the database.
* *Use Original Authentication Credentials* \- Connects using the default username and password used to backup the database instance.
* *Specify Alternate Authentication Credentials* \- Allows you to set 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.

Select the second option.
!alt4.png!

Enter the required credentials.
!alt5.png!

Click "Next" to proceed to the following step.
!restore-wizard-next.png!

9. The next screen is "Temp Instance." When restoring databases, the system needs to create a temporary directory on the target agent for the restore. There are two options for this.
* *Use Default Temp Directory* \- Creates a directory in an OS-specific default location ({color:blue}C:\Temp{color} for Windows, {color:blue}/tmp{color} for Linux).
* *Specify an Alternate Temp Directory* \- Allows you to control exactly where the {color:blue}temp{color} directory is created on the Agent.
!alt6.png!

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

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

!restore-wizard-next.png!

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 we can locate the data files for the database during the restore.

!http://youngcopy.net/handynetworks/images_for_confluence/alt8.png! !alt8.png!

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.

!http://youngcopy.net/handynetworks/images_for_confluence/alt9.png! !alt9.png!

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

...