MySQL table 1016 error

[trimast]

Hi all,

I've been getting the following error:

#1016 - Can't open file: 'table_name.MYI'. (errno: 145)

for a few days now, the biggest problem is that its freezing the entire site and no searches can be performed as the table in question is the search log table.

Anybody any ideas on how to fix it?

Thank in advance

Rob

[kris1234]

Enter into mysql command prompt, select this database.

And fire this command

Repair table name

It should fix the problem .

If this problem still exist there , then go into this database directory, normally this is like /var/lib/mysql/databasename

and check owner of files , all files should have mysql.mysql

Regards

Kris

[trimast]

Thanks for such a quick responce.

This site is on a shared server, the only access i have to the mysql is via phpmyadmin. Am i able to do that via phpmyadmin or will it be a case of getting the hosting company to do the job?

Thanks once again

Rob

[kris1234]

fire this command

Repair table name

This can managed thru PHPMyAdmin

Kris

[trimast]

Thanks,

Worked just as you said - the site is now fully working again!

Many thanks

Rob