MySQL Forums
Forum List  »  Backup

Re: Restore MYSQL Backup With New Database Name
Posted by: Rick James
Date: December 12, 2011 09:06PM

Find the option to mysqldump that avoids creating the CREATE DATABASE statement. Then provide the database name when loading:
mysql -u... -p... NAMEB <dump.sql

(Note: you will have to manually do CREATE DATABASE NAMEB

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Restore MYSQL Backup With New Database Name
1486
December 12, 2011 09:06PM


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.