MySQL损坏数据的恢复

核心提示： - check index reference- check data record references index: 1- check data record references index: 2- check data record references index: 3- che

- check index reference

- check data record references index: 1

- check data record references index: 2

- check data record references index: 3

- check record links

myisamchk: error: Wrong bytesec: 0-195-171 at linkstart: 841908

MyISAM-table 'c:mysqldatahw_enterpricefunction_products.myi' is corrupted

Fix it using switch "-r" or "-o"

继续进行操作：

C:mysqlin>myisamchk --recover --quick　c:mysqldatahw_enterpricefunction_p

roducts.myi

- check key delete-chain

- check record delete-chain

myisamchk: error: record delete-link-chain corrupted

myisamchk: error: Quick-recover aborted; Run recovery without switch 'q'

Updating MyISAM file: c:mysqldatahw_enterpricefunction_products.myi

MyISAM-table 'c:mysqldatahw_enterpricefunction_products.myi' is not fixed be

cause of errors

Try fixing it by using the --safe-recover (-o) or the --force (-f) option

系统提示我使用--safe-recover (-o) or the --force (-f) option进行修复操作，于是

C:mysqlin>myisamchk --safe-recover　c:mysqldatahw_enterpricefunction_prod

ucts.myi

- recovering (with keycache) MyISAM-table 'c:mysqldatahw_enterpricefunction_

products.myi'

Data records: 85207

Wrong bytesec:　 0-195-171 at　　 841908; Skipped

Data records: 85215