Re: Importing/Restoring Multiple mysqldumps to One Database

[Matt Pellegrino]

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