|
Joined: Oct 2007
Posts: 464 Likes: 11
Addict
|
Addict
Joined: Oct 2007
Posts: 464 Likes: 11 |
My owners just informed me that they have lost one thread in one forum. I told them that if I restored from backup, they would lose everything that's happened since the backup. Is there a way to restore ONE thread from backup? (I imagine it would be complicated if it can be done at all.)
I could install a dummy instance of the forum and load a backup, but no idea how I would "copy" that one thread over to the live forum.
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
Cry Uncle and be done with it. Because it is not one table impacted so if anyone posted since the delete ?????? Most of us have a archive forum to move them to instead of deleting them for this very reason. This is sop. Here the forum is called the boneyard only accessible to moderators and admins.
The best thing to do is manually recreate the post so it updates the topic , post tables and adds back to the recent posts and user
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Oct 2007
Posts: 464 Likes: 11
Addict
|
Addict
Joined: Oct 2007
Posts: 464 Likes: 11 |
I already told them it was likely a no go. I think I'll leave it at that and say, Next time, be more careful. 😊
|
|
|
|
Joined: Jun 2006
Posts: 16,365 Likes: 126
|
Joined: Jun 2006
Posts: 16,365 Likes: 126 |
It's possible but we're talking hours of work to get the data recreated in the database... I'd advise a trash can forum for future issues.
|
|
|
|
Joined: Aug 2006
Posts: 1,359
Veteran
|
Veteran
Joined: Aug 2006
Posts: 1,359 |
I think more time would go into thinking "how would I do this again?" then the actual restore.
I would consider this very doable. I don't expect any data conflicts, since id's are not reused. All in all doable, but also time consuming because you want to do this really really carefull.
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
long ago in a galaxy far away there was talk of a board merge feature that would apply here
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Oct 2007
Posts: 464 Likes: 11
Addict
|
Addict
Joined: Oct 2007
Posts: 464 Likes: 11 |
I think more time would go into thinking "how would I do this again?" then the actual restore.
I would consider this very doable. I don't expect any data conflicts, since id's are not reused. All in all doable, but also time consuming because you want to do this really really carefull. Every post ties to a user id, a forum id, and a topic id. The complexity of it is far beyond my capabilities. I'd rather chalk it up to lessons learned and tell people to think twice before deleting an entire thread.
|
|
|
0 members (),
1,613
guests, and
50
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|