MySQL Forums
Forum List  »  Backup

Restore MYSQL Backup With New Database Name
Posted by: eric toll
Date: December 11, 2011 07:09PM

I am running 5.5 under Windows XP - And Developing in VB2010.net .

I have sucessfully backed up the full database NAMEA with mysqldump.exe.

I Can sucessfully restore the .SQL file back to the NAMEA database.

I would like to restore back to a different name - ie NAMEB so that I dont overwrite the original at that point.

Sofar, all I can get to work is editing the .SQL file manually to replace the NAMEA references to NAMEB - and then it works.

However, since many websites suggest you can copy a database by piping the output of mysqldump into mysql - I was expecting to be able to able to specify NAMEB in the mysql command line so that it overrides the NAMEA's embedded in the .SQL

Surely my need to restore to a different name, or copy database A to B with the standard utilities is not rocket science.

Options: ReplyQuote


Subject
Views
Written By
Posted
Restore MYSQL Backup With New Database Name
4437
December 11, 2011 07:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.