PDA

View Full Version : Recovering from ISP Outage: How do I merge in missing SQL data?


gopherhockey
Sun 20th Aug '06, 10:21pm
F5hosting tried to do a server migration today and failed. What we ended up with, for some reason, was our old server that is now missing a day or more of posts and activity from our forums.

I am getting our ISP to give me a sql backup from last night at midnight. However, since the site came back online there are new posts as of today.

My question is, how can I merge in the missing data that is mostly from 8-19-06? Can I pull in the posts and threads that are gone, or am I SOL on getting my data back?

I have no idea why F5hosting cut out that data. I can only assume they did some kind of sql restore from old data and/or didn't do a backup just before they tried their migration. A 12 hour outage on a weekend and a full day + of missing sql data. Nice... :mad:

Colin F
Mon 21st Aug '06, 5:43am
I doubt that you'll be able to merge in the missing data. Primarily, because the ids will be taken by the new threads. You'd have duplicate thread and postids, which would give conflicts and errors.