Hi,

I accidentally deleted an entire section of our Forum, complete with hundreds of topics and posts. I was astonished to find that only one confirmation dialogue allows the complete deletion of such a mass of data, but that is another issue. I had a backup from a few days earlier but couldn't restore the whole thing as I would have lost all of the forum's recent activity.

I know the specific ForumIDs that were deleted and as an intermediate SQL/web developer, I restored the backup to a new temporary database and then delved into the backend structure. I used INSERT INTO queries to reinsert the data that matched the deleted ForumIDs whilst maintaining the original column identification autonumbers so that referential integrity was maintained.

The tables that I've been working with are:-

activeforums_Forums
activeforums_ForumTopics
activeforums_Forums_Trackingactiveforums_Groups
activeforums_Topics
activeforums_Topics_Tracking
activeforums_Content
activeforums_Replies

I get very close to a successful restore but (a) end up with some duplicates and (b) the replies are not appearing.

All I want to know is whether there are any other tables that I have overlooked that tie these together? A relationship diagram would be great but I guess that would be too much to ask. Any other tips or comments?

Thanks in advance.

I don't really have any experience restoring deleted content.

I am not sure why the replies would not be shown as long as the TopicIds are correct, and they are not set to "IsApproved: False" or something.

A sample row of data in the replies table should look like:

1 1 1 2 True False 0 False