Previous Thread
Next Thread
Print Thread
Hop To
Joined: Oct 2007
Posts: 388
Likes: 8
Enthusiast
Enthusiast
Joined: Oct 2007
Posts: 388
Likes: 8
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.


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 7.7.5
Release 20201027
Server OS Linux
Server Load 0.16
Web Server Apache/2.4.6
PHP Version 7.4.33
MYSQL Version 8.0.37
Database Size 1.78 GB
Joined: Dec 2003
Posts: 6,592
Likes: 78
Joined: Dec 2003
Posts: 6,592
Likes: 78
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: 388
Likes: 8
Enthusiast
Enthusiast
Joined: Oct 2007
Posts: 388
Likes: 8
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. 😊


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 7.7.5
Release 20201027
Server OS Linux
Server Load 0.16
Web Server Apache/2.4.6
PHP Version 7.4.33
MYSQL Version 8.0.37
Database Size 1.78 GB
Joined: Jun 2006
Posts: 16,310
Likes: 117
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,310
Likes: 117
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.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Aug 2006
Posts: 1,359
Y
Veteran
Veteran
Y Offline
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.


[Linked Image from siemons.org]
Joined: Dec 2003
Posts: 6,592
Likes: 78
Joined: Dec 2003
Posts: 6,592
Likes: 78
long ago in a galaxy far away there was talk of a board merge feature that would apply here laugh


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Oct 2007
Posts: 388
Likes: 8
Enthusiast
Enthusiast
Joined: Oct 2007
Posts: 388
Likes: 8
Originally Posted by Yarp
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.


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 7.7.5
Release 20201027
Server OS Linux
Server Load 0.16
Web Server Apache/2.4.6
PHP Version 7.4.33
MYSQL Version 8.0.37
Database Size 1.78 GB

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Repeatable issue for file attachments
by Baldeagle - 07/14/2024 11:24 PM
I know this is not the right forum for this
by Baldeagle - 07/11/2024 9:54 PM
topic timestamp does IP lookup of poster?
by Ruben - 07/09/2024 11:36 AM
shoutchat posts do not stay when migrating hosts
by Ruben - 07/07/2024 2:14 PM
Is it possible to restore ONE thread from backup?
by Baldeagle - 07/06/2024 1:02 PM
Who's Online Now
2 members (Baldeagle, Ruben), 75 guests, and 106 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)