Welcome to the OzoneAsylum FaqWiki
Frequently Asked Questions
Server Side Coding
MySQL

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:

quote:
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):

quote:
REPAIR TABLE something



or from the command line:

quote:
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.

_________________
Emperor

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

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

« BackwardsOnwards »

Show Forum Drop Down Menu