REPAIR TABLE ubbt_FORUMS

REPAIR TABLE ubbt_TOPICS

Are the above commands entered through mysql? If so, I assume I need to issue a USE ubbthreads statement first.

Should I have the message board set in maintenance mode?

Thank you.

You should put it in maintenance mode, but use the mysql tools section in your control panel, the second tab. Use the commands as written.

I will have to wait until late tonight to do this when I can boot users off the system for a while.

I will report back on the results.

Thank you.

As a side note, the 2 sticky posts and global announcements show "-1" in the Replies column in the Forum/Topics list page. They should show 0. Obviously this further flags these as problems.

Those two topics were added to the board long before the backup was taken that was used in the restore. So something in either the sql load or the ubbthreads content rebuilder scrips got those posts messed up.

I will run the REPAIR commands later tonight and will report back.

Sure, each command should only take a few seconds to run at most, and run them separately - repair the topics then forums.

I though I'd report back on the final resolution to this problem.

I discovered by looking through some of the forums that there were a number of posts missing and some users were missing, too. A further investigation showed that it appeared that not all records were exported successfully during my backup. I had been using phpMyAdmin to do an export. I broke up the tables into 4 groups because some (like the posts table) were really large. But even doing this missed some records possibly due to a query length limit restriction.

So I booted up my old master drive and did the backup via mysqldump from root on the system. That worked and got all the records into one file.

I did do the rebuild scripts anyway just to be sure. Even the sticky posts and global announcements that I couldn't access before were fixed.

I appreciate everyone's input above.