For the rest of you that have spent hours searching for how to fix the problem with the wordpress table (or any other table for that matter) that needs to be flushed because it didn’t get closed properly, here’s the short and sweet story of how to do it and get on with your life.
First, you can try going into phpMyAdmin and flushing the table, but that didn’t work for me. I fortunately have SSH access to the server, so I got in to the server and then issued the following:
mysql -u USER_NAME -p TABLE_NAME
Obviously, you need to substitute your own username and table name.
Once you’re into the mysql prompt, all you need to type is:
repair table wp_comments;
or, if you have another table to repair, the name of the table there.
Good luck! BTW – Comments should be working again. It was kind of nice not getting spam constatly while they were down though!