PDA

View Full Version : MySQL error


CloudSlash
06-22-2002, 02:36 PM
SQL-query : [Edit]

SELECT * FROM `user` LIMIT 0, 30

MySQL said:

Can't open file: 'user.MYD'. (errno: 145)

Can anyone please help me fix this

Logician
06-22-2002, 03:08 PM
last resort try:
SELECT * FROM user LIMIT 0, 30

if same error comes up, it's db corruption, repair it.

CloudSlash
06-22-2002, 03:20 PM
see right now my forums are down because of this, and how would I repair it

Steve Machol
06-22-2002, 05:29 PM
Run this query in phpMyAdmin:

REPAIR TABLE user;

CloudSlash
06-24-2002, 04:16 PM
thanks. I did that and it work, now I have another one and I need your help it says

Error
SQL-query : [Edit]

SHOW KEYS FROM `user`

MySQL said:

Can't open file: 'user.MYD'. (errno: 145)

Back

please help

Steve Machol
06-24-2002, 04:34 PM
That's still a corrupted user table. Run this query again:

REPAIR TABLE user;