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:
both report Incorrect Key File error
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:
When looking at the structure view the tables that are corrupt show as In Use:
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!