I have got repeated error message like "Can’t open file: ’accesslog.MYD’. (errno: 145)". Actually, I can’t access the table named accesslog for any purposes including read or write. This table is not so important for me but it’s a kind of some annoying. I can’t even dump the database to back it up. I tried to search for this similar problem in Google using keyword "". There are about 900,000 search results. Great! What is the cause of this problem? The host that I got that error message is FreeBSD. I also got it in Linux. OS might not be the problem. So the problem seems to be MySQL itself. I don’t know.

Fortunately, MySQL offers a command to repair that tables and files.

repair table accesslog

Replace "accesslog" by your corrupted table one by one. Hope it works for you.

Technorati Tags: English, IT, Software, Tips and Tricks, MySQL, Error 145