Welcome to the OzoneAsylum FaqWiki
Frequently Asked Questions
Server Side Coding

What does "errno: 145" mean in MySQL? Pages that link to <a href="https://ozoneasylum.com/backlink?for=5391" title="Pages that link to What does &amp;quot;errno: 145&amp;quot; mean in MySQL?" rel="nofollow" >What does &quot;errno: 145&quot; mean in MySQL?\

If you get an error like:

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

The it seems like that the table 'something' has become corrupted.

There are a number of fixes that can be done from within MySQL. You can use SQL (which for the record worked like a dream for me):

REPAIR TABLE something

or from the command line:

myisamchk -r something

If that doesn't work and you've looked into the help (through the command line or through the manula - see links below) and it is non-essential then delete it and reconstruct it (in my research for this problem it does seem like the error commonly affects a table used for storing sessions and so getting rid of this will just mean that everyone will have to log in again) - if it is vital then now is the time that you thank your lucky stars that you have been making regular backups of your database...... You have been making backups haven't you?

Relevant links:

Corrupted MyISAM Tables - from the MySQL manual

MySQL problem

How to use myisamchk?

cant find file gforum_Session.MYD

Login Error - Can't login

Relevant notes:

As of the time of writing this FAQ was ranked number 3 at Google for the terms mysql, errno:, 145.


(Added by: Emperor on Mon 04-Nov-2002)

(Edited by: Emperor on Wed 04-Dec-2002)

« BackwardsOnwards »

Show Forum Drop Down Menu