By uNeedStuff on

My site isn't working and it looks like my user table is missing. When I go into PHPMyAdmin and click on users I'm receiving the following:

Error

SQL query: Edit

SHOW INDEX FROM `users` ;

MySQL said: Documentation
#1016 - Can't open file: 'users.MYI' (errno: 145)

Is there anything I can do? Also how could this happen? any type of help or direction would be appreciated.

Shari

⋅ Categories: Drupal 5.x

Comments

N6546R’s picture

N6546R commented

Just hit this on my site. I assume all I can do is a restore...any idea what causes this?

N6546R’s picture

N6546R commented

The MYI file is a MySQL index file. I repaired the index and things went back to normal. Here's a link to the v5 doc page: http://dev.mysql.com/doc/refman/5.0/en/repair-table.html

There was no data loss, once the index was repaired all rows were present.