Recently I moved a bunch of threads to other forums using this command:
UPDATE mybb_threads SET fid='x' WHERE fid='y'
However, this only changed the fid... I made the huge mistake of deleting the forums and I didn't realize the actual posts in the threads hadn't been moved as well this until recently when I saw all the threads I'd moved had no data.
The thread was there, but there's no posts for them (click on them and "this thread does not exist". No info for last poster etc... Only thread ratings and views and name of thread... See attached pic)
I have a backup from about a month ago...What I'd like to do is to restore the data to these threads. Whether it's done by restoring the forums, or if it's possible just restore the thread's data.
If restoring the entire forums, there could then be the issue of duplicated threads (because the "blank" threads exist in other forums now)... So I'm not sure how this is best handled