userfield.MYD MySQL Error

[Steve Machol]

If you get an error like this:

mysql error: Can't open file: 'userfield.MYD'. (errno: 145)
Be aware that repair.php does not work on the user or userfiled tables. Instead, run this query to fix the table (courtesy of Ed Sullivan):

From this thread (http://www.vbulletin.com/forum/showthread.php?s=&threadid=18856&highlight=userfield.myd):

MySQL marked the userfield table as crashed, so you need to repair it.

You can run this query via phpMyAdmin or telnet:

REPAIR TABLE userfield;

[eva2000]

yup there are actually 3 ways to do this:

1. via phpmyadmin

using query

REPAIR TABLE user;

2. or using mysqlcheck repair for 3.23.38 and above

i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:

mysqlcheck -r -u mysqlusername -p databasename

3. via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :

myisamchk -r -u root -p databasename

option #3 most likely requires server and mysql root access to first stop mysql and then run myisamchk repair options.