[[email protected]]# myisamchk _con_postmeta.MYI
Checking MyISAM file: _con_postmeta.MYI
Data records: 213040
Deleted blocks: 3
myisamchk: warning: Table is marked as crashed and last repair failed
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: error: Found 73 keys of 213040
- check record links
myisamchk: error: Keypointers and record positions doesn't match
MyISAM-table '_con_postmeta.MYI' is corrupted
Fix it using switch "-r" or "-o"
[[email protected]]# myisamchk -r _con_postmeta.MYI
- recovering (with sort) MyISAM-table '_con_postmeta.MYI'
Data records: 213040
myisamchk: error: Can't create new tempfile: '_con_postmeta.TMD'
MyISAM-table '_con_postmeta.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag
[[email protected]]# myisamchk --safe-recover _con_postmeta.MYI
- recovering (with keycache) MyISAM-table '_con_postmeta.MYI'
Data records: 213040
myisamchk: error: Can't create new tempfile: '_con_postmeta.TMD'
MyISAM-table '_con_postmeta.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag
[[email protected]]# myisamchk --force _con_postmeta.MYI
Checking MyISAM file: _con_postmeta.MYI
Data records: 213040
Deleted blocks: 3
myisamchk: warning: Table is marked as crashed and last repair failed
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: error: Found 73 keys of 213040
- recovering (with sort) MyISAM-table '_con_postmeta.MYI'
Data records: 213040
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
....