missing user table
WebWeaver64 - May 8, 2007 - 15:11
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
Same here
Just hit this on my site. I assume all I can do is a restore...any idea what causes this?
Fixed
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.