MySQL Forums
Forum List  »  Data Recovery

Re: Importing/Restoring Multiple mysqldumps to One Database
Posted by: Matt Pellegrino
Date: October 04, 2009 10:51PM

Hello,

The above will work but you may run into a problem with your primary keys if all three imports start from say index 1. During the import you might see an error for "Duplicate entry xxxx for key #" which basically means you are attempting to import a value that already exists in a unique column. You could try and generate new unique IDs using information from the following:

http://dev.mysql.com/doc/refman/5.1/en/example-auto-increment.html

Or maybe just specify the tables new starting place:

ALTER TABLE theTableInQuestion AUTO_INCREMENT=1234


Matt Pellegrino
Support Engineer
mpellegrino @ hosting.com
www.Hosting.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Importing/Restoring Multiple mysqldumps to One Database
2733
October 04, 2009 10:51PM


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.