MySQL Forums
Forum List  »  Data Recovery

Incorrect key file for table './xxx/xxxt.MYI'; try to repair it
Posted by: Pat Mustard
Date: February 10, 2009 05:05AM

I've used myisamchk to repair the table several times, seamingly without problems, but the error keeps coming back:

myisamchk --force --sort_buffer_size=64M --key_buffer_size=16M --read_buffer_size=8M --write_buffer_size=8M xxx
Checking MyISAM file: xxx
Data records: 1890046 Deleted blocks: 0
myisamchk: warning: Table is marked as crashed
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: error: Found 1890041 keys of 1890046
- recovering (with sort) MyISAM-table 'xxx'
Data records: 1890046
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5

I've also tried myisamchk using -r -q

I'm aware that there are medium and extended checks, but these seem geared more towards the data itself, whereas my problem appears to be with the index/keys. I'm cautious about taking my site down for an extended check too - it's a busy forum, and even the quick check takes 15 minutes.

Any thoughts please? Would dropping the keys then re-adding them help?

Options: ReplyQuote

Written By
Incorrect key file for table './xxx/xxxt.MYI'; try to repair it
February 10, 2009 05:05AM

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.