Previous Thread
Next Thread
Print Thread
Hop To
#43207 11/21/2004 2:39 AM
Joined: Jan 2004
Posts: 174
R
member
member
R Offline
Joined: Jan 2004
Posts: 174
We recently had some trouble with our database and it had to be repaired. The forum is now running fine, but one particular forum is showing posts from August on the first page, so about 20-25 pages of posts are missing. Is there some way to rebuild the threads or some way I can try and get the old posts back?

Thanks,
http://www.highlifter.com/ubbthreads

#43208 11/21/2004 10:01 AM
Joined: Nov 2004
Posts: 28
D
newbie
newbie
D Offline
Joined: Nov 2004
Posts: 28
When you are talking about repaired you mean with the Repair of MySQL or you just dumped the database and used a backup to restore/recreate it?

If it is the backup then the threads are gone if they were created after the time you took the backup.

Regarding the Repair function of MySQL I had seen in the past some corruption in the w3t_Users table of one of my boards and when I used the Repair function certain records were indeed missing (including one of my moderators <img src="https://www.ubbcentral.com/boards/images/graemlins/tongue.gif" alt="" />). So to the best of my knowledge the answer would be no (reluctantly)


Nikos

Web Desing/Programming: http://niden.net
#43209 11/21/2004 6:42 PM
Joined: Nov 2004
Posts: 2
T
stranger
stranger
T Offline
Joined: Nov 2004
Posts: 2
RANCH4x4, fancy seeing you here. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

dimopoulos, I work with RANCH4x4, I did a "repair table w3t_Posts" as that was the one in the query that I could not select from.

#43210 11/21/2004 7:06 PM
Joined: Nov 2004
Posts: 2
T
stranger
stranger
T Offline
Joined: Nov 2004
Posts: 2
What about rebuilding the indexes? Seems like we have run into this before.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
0 members (), 815 guests, and 186 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 20240501)