|
How to restore MySQL from another server |
|
|
|
|
Written by repostor
|
|
Tuesday, 22 September 2009 19:43 |
How to restore to another serverHere is the scenario: You would like to restore serversource to serverdestination. Restore using the ASNODE example:
- Both serverserversource and serverdestination must be registered on the same TSM server
- Log on to the TSM server and run "grant proxynode target=serversource agent=serverdestination"
- On the serverdestination client, add the "ASNODE serversource" entry to the dsm.opt/sys file
- Execute the mysqlrestore command to restore the data
Restore using the same node entry example:- This example requires that you know the serversource password.
- copy the dsm.opt/dsm.sys from serversource to serverdestination
- On the serverdestination, run dsmc -se=serversource (this will save the password on the serverdestination)
- Execute the mysqlrestore command to restore the data
|
|
Last Updated on Tuesday, 22 September 2009 19:51 |