PDA

View Full Version : Restoring a database backup to a database with*a different name



lylo
January 8th, 2010, 01:31 AM
Hi

I'd like to use the mysql-zrm-restore command to restore my production database to my staging database. As far as I can tell, the restore process only restores a backup to a database of the same name, not a differently named database.

Is it possible to do this?

Olly

paddy
January 8th, 2010, 11:25 AM
The restore process does not have capability to restore the database to different name. Alternatively, you can restore to different MySQL server. This allows you to run any MySQL application that uses the database.

Paddy