PDA

View Full Version : Restore to Windows mysql?



mpopetz
October 20th, 2008, 11:42 AM
Hello All,
I have a backup from our production systems taht I want developers to install on their local (windows) machines for testing. They have no local unix machine to run the zrm restore.

Looking at the uncompressed backup_data, it appears to be pretty vanilla but has some funky stuff at the start that stops me from just piping it into mysql via the command line.

Is there a way to restore on of these backups to a windows mysql install?

paddy
October 20th, 2008, 12:38 PM
From your description, it appears that you are using logical backups. You should be able to restore to windows machine as long as the MySQL server on the windows machine is compatible with production machine.

Paddy

mpopetz
October 20th, 2008, 12:43 PM
Yep, doing logical backups...but without the zrm tools, how does on restore a logical backup?

paddy
October 20th, 2008, 01:53 PM
Yep, doing logical backups...but without the zrm tools, how does on restore a logical backup?

If you are not using compression or encryption, you should be able provide the backup image as input to mysql command.

Paddy