MySQL DB corrupted will PAY for help!
- recovering (with keycache) MyISAM-table '/backup/mysql/ianag/post.MYI'
Data records: 2839711
Wrong bytesec: 28- 85- 1 at 2821928176; Skipped
Data records: 2839710
I've followed all steps on http://dev.mysql.com/doc/mysql/en/repair.html and all of the DB dumps I've tried restoring (daily for the past 7 days) ends up with this same error. I've tried truncating the table and restoring the .MYD file then running the repair on the .MYI even.
I've tried myisamchk -r -q along with -r and even -f
myisamchk -e comes up with this:
Data records: 2839710 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
myisamchk: error: Key in wrong position at page 220871680
- check records and index references
myisamchk: error: Record at: 2664509404 Can't find key for index: 4
MyISAM-table '/backup/mysql/ianag/post.MYI' is corrupted
Fix it using switch "-r" or "-o"
I've been running the repair tool many times in many different variations and I keep getting some kind of error message. Any suggestions?
