Merge two mySQL databases.

[FreeStream]

Hi,

I have two mySQL databases.

They are essentially, exactly the same.

However one is from March this year and the other is from today.

I.e. the march one is a backup that was taken in March.

Now there are entries (Exactly speaking iPhone SMS messages) that were deleted by mistake.

Is there a way of merging the messages back into the newer database?

There is a date and time column of data so getting them back into the correct 'slot' shouldn't be too hard.

Ideas?

Thanks!

 

[FreeStream]

Can I actually upload my iPhone's SMS database to PHPMyAdmin and do that?

I don't think the ID's are important as when you delete an SMS all the messages get bumped down one and they retain their own ID.

I.e. If message 12111 (row 12111) is deleted then the messages jump from 12110 (row 12110) to 12112 (row 12111).