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;
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.