Events Calendar

September 2010
M T W T F S S
30 31 1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 1 2 3

Select Language

How to restore MySQL from another server PDF Print E-mail
Written by repostor   
Tuesday, 22 September 2009 19:43

How to restore to another server

Here is the scenario:

You would like to restore serversource to serverdestination.

Restore using the ASNODE example:

  1. Both serverserversource and serverdestination must be registered on the same TSM server
  2. Log on to the TSM server and run "grant proxynode target=serversource agent=serverdestination"
  3. On the serverdestination client, add the "ASNODE serversource" entry to the dsm.opt/sys file
  4. Execute the mysqlrestore command to restore the data

Restore using the same node entry example:

  1. This example requires that you know the serversource password.
  2. copy the dsm.opt/dsm.sys from serversource to serverdestination 
  3. On the serverdestination, run dsmc -se=serversource (this will save the password on the serverdestination)
  4. Execute the mysqlrestore command to restore the data

 

Last Updated on Tuesday, 22 September 2009 19:51
 
Repostor : Your recovery expert