Draft (please comment): Can't open file: 'TABLE.MYI' (errno: 145)

Please comment on the rough draft below.  I saw a post on this recently in the forum, and thought it would be a nice candidate for the Trouble shooting faq.

===================

http://drupal.org/node/85866

This is for errors like this:

user error: Can't open file: 'accesslog.MYI'. (errno: 145)
query: INSERT INTO accesslog (title, path, url, hostname, uid, timestamp) values('story', 'node/add/story', '.../node/add/story', '000.0.000.000', 1, 1146151588) in .../includes/database.mysql.inc on line 66.

errno: 145 is a MySQL error.

MySQL error code 145: Table was marked as crashed and should be repaired

(source: http://drupal.org/node/60693)

In this case, the affected table is accesslog.

BACK UP YOUR TABLE!

Possible solutions.

1) Please repair your table.

In phpmyadmin:
Select your database
check the corrupted table
scroll down and select the option "repair table".

from mysql command line:

repair table tablename;

2) Empty your table.
Be sure you know what you are doing!

===================

Anisa.

-- 
*********************************
www.AnimeCards.Org

16,000 scans and counting!
*********************************
--
Pending work: http://drupal.org/project/issues/documentation/
List archives: http://lists.drupal.org/pipermail/documentation/