MySQL Forums
Forum List  »  MySQL Administrator

Advanced Search
New Topic

Re: db backup and restore to another db using mysqldump
Posted by: Scott Nemes
Date: January 23, 2012 05:39PM

Your mysqldump script has a "use db1" statement near the top; that is why it is inserting the data into db1 instead of db2. If you change that statement to "use db2" instead, it will insert the data into db2.

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
db backup and restore to another db using mysqldump
ahmad gholi
January 18, 2012 06:23AM
Re: db backup and restore to another db using mysqldump
Scott Nemes
January 23, 2012 05:39PM


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.