MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

Re: Incorrect key file for table 'XXX.MYI'; try to repair it
Posted by: Rick James
Date: April 14, 2010 11:06PM

Has the server crashed (eg, power failure)? You don't simply power off you Windows box, do you? (That would not give mysql a chance to flush the key_buffer to disk.)

Has mysql crashed? Or is the table spontaneously "crashing" while mysql is running?

You did REPAIR TABLE? Or mysamchk?

Almost sounds like a bad spot on disk. If so, this might 'fix' it:
1. Stop mysql
2. rename the .myi file to something else, like "DISK.BAD".
3. restart mysql
4. REPAIR TABLE -- MySQL will see that the .MYI file is missing and rebuild it. But this time, it will be in a different spot on disk.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Incorrect key file for table 'XXX.MYI'; try to repair it
110282
Hava Ba
April 13, 2010 09:43AM
Re: Incorrect key file for table 'XXX.MYI'; try to repair it
58332
Rick James
April 14, 2010 11:06PM
Re: Incorrect key file for table 'XXX.MYI'; try to repair it
38601
Shane Bester
April 19, 2010 06:39AM
Re: Incorrect key file for table 'XXX.MYI'; try to repair it
31177
Hava Ba
April 21, 2010 04:57AM
Re: Incorrect key file for table 'XXX.MYI'; try to repair it
24963
Rick James
April 24, 2010 08:37PM
Re: Incorrect key file for table 'XXX.MYI'; try to repair it
21951
Hava Ba
April 25, 2010 04:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.