Restoring from an incomplete database dump

[valdet]

Hi there,

I am trying to help a friend of mine in restoring a database from an incomplete database SQL dump file.
Yesterday, he had the worst nightmare of website owners: Server crash.

Unfortunately for him the hosting company backup server had also crashed and the latest available database and file backup that hosting company had for him is two weeks old backup.

Few days ago he did a backup of vBulletin database from vB Admin Panel, but it turned out that it was not completed. The last table to be downloaded was vboard_user table.

I want to help him restoring as much content as possible, but the most important are tables: post, thread and user.

Now i have both database dumps available. original.sql (2 weeks old) and backup.sql (more recent - 3 days old).

I want to see if someone has an experience or could advise me on which best options are available to merge the contents of these two dumps or update original.sql with fresh content from backup.sql

In my head I am thinking of taking the backup.sql and doing a mass replace of data from

INSERT INTO `vboard_xxxx`

to

REPLACE INTO `vboard_xxxx`

and import it into database. In that way I presume all contents of backup.sql will be added to current original.sql.

Or I may go the otehr way around of creating a completely new database on phpMyAdmin and copying the contents from both of these dumps into the new database.

I found some resources, but I am not sure if these would work in my case, because both files have many tables with same records (older threads, older posts, older users etc..)

http://www.ozzu.com/programming-foru...in-t49395.html
http://www.daniweb.com/forums/thread145892.html



Can you please give me any clues how would you best solve this difficult thing.

I would hate if I have to go one by one on my backup file and isenrting the threads and posts manually through sql statements.


Thanks and I appreciate any comments you might have.

Regards,
Val.