MySQL损坏数据的恢复

核心提示： Other actions:-a, --analyze Analyze distribution of keys. Will make some joins inMySQL faster.You can check the calculated distributionby using &

Other actions:

-a, --analyze　　　 Analyze distribution of keys. Will make some joins in

MySQL faster.　You can check the calculated distribution

by using '--description --verbose table_name'.

-d, --description　 Prints some information about table.

-A, --set-auto-increment[=value]

Force auto_increment to start at this or higher value

If no value is given, then sets the next auto_increment

value to the highest used value for the auto key + 1.

-S, --sort-index　　Sort index blocks.　This speeds up 'read-next' in

applications

-R, --sort-records=#

Sort records according to an index.　This makes your

data much more localized and may speed up things

C:mysqlin>myisamchk c:mysqldatahw_enterpricefunction_products.frm

myisamchk: error: 'c:mysqldatahw_enterpricefunction_products.frm' is not a M

yISAM-table

C:mysqlin>myisamchk c:mysqldatahw_enterpricefunction_products.myi

Checking MyISAM file: c:mysqldatahw_enterpricefunction_products.myi

Data records:　 85207　 Deleted blocks:　　　39

myisamchk: warning: Table is marked as crashed

myisamchk: warning: 1 clients is using or hasn't closed the table properly

- check file-size

- check key delete-chain

- check record delete-chain

myisamchk: error: record delete-link-chain corrupted