troubleshooting Question

Incorrect Key File for table smf_members

Avatar of Karl_mark
Karl_mark asked on
MySQL Server
4 Comments1 Solution549 ViewsLast Modified:
Hi,
A messageboard on which I am an administrator has recently gone down. Although I am an administrator, I do not own the site and the owner and I have been meaning to upgrade to a later version of smf for some time but never quite got round to it! Anyway, the webhost recently dumped us on to a new version of smf as well as MYSQL which has left the site down. There seem to be a few tables with the same issue:
Incorrect Key File for Table x; try to repair it.
I've tried repairing it using the extended option but to no avail. There is a slight difference in some of the messages though:

smf_members
smf_boards

both report Incorrect Key File error

smf_log_errors
reports :
Table upgrade required. Please do "REPAIR TABLE `smf_log_errors`" or dump/reload to fix it!

If I try to run Repair Table smf_log_errors I get:

Error Message
When looking at the structure view the tables that are corrupt show as In Use:

Structure View
The version of MYSQL is 5.0.8.

We could try rolling back to an earlier backup, but the owner has mislaid them on various hard drives which he'll need to reconnect to a pc somewhere!
ASKER CERTIFIED SOLUTION
Karl_mark

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros