Repair/Optimize = crashed tables.

[Chris-777]

I'm not sure if there's really a solution here, but this is getting rather old. This is the third or fourth time I've had to restore from a backup because the R/O in the AdminCP ends up timing out and corrupting/crashing my post table.

I didn't even repair this time, just optimize to clean up a small bit of overhead on 8 different tables. The ACP hangs up, and I end up with a dead forum. I'm currently myisamchk-ing (again) from a shell.

It seems like the ACP options are only meant for folks with small databases.

[Jake Bunce]

The script may timeout in the middle of the process, but the command should still complete on the server afterwards. For large databases it can take some time during which time the forum may be slow because of the processing on the server.

For repairing excessively large tables sometimes you have to run the command at the mysql prompt. If you have shell access to the server then try logging into the mysql prompt with this command:


mysql -uusername -ppassword databasename


Then run this command at the mysql prompt:


REPAIR TABLE post;