Import only non-existing records

[bstonehill]

I recently moved Sugar to a new server. I did an upgrade from 4.5.1 to 5.1RC in order to apply the necessary changes to the database structure. I then exported the database as SQL and imported it into a new 5.1RC install. I checked the record count and it appeared that all records were imported successfully. After a few weeks though we started noticing records missing. I still have the original database on the old server. I want to redo the import to hopefully get back any missing records but I don't want to overwrite any of the records that are already in the new database because I don't want to lose any updates or additions that have been made since.

How can I import that backup without overwriting existing records?

[Angel]

Perhaps the easiest thing to do would be to import the entire table from the other server onto your new server, but give it a different name (or rename the existing table on the new server that happens to share its name). You should then be able to execute a INSERT INTO..SELECT statement that appends the difference between the two tables into the production table. You could base your comparison on the ID column as it should be unique for each entry.