MySQL损坏数据的恢复

核心提示： -V, --version Print version and exit.-w, --waitWait if table is locked.Check options (check is the default action for myisamchk):-c, --check Chec

-V, --version　　　 Print version and exit.

-w, --wait　　　　　Wait if table is locked.

Check options (check is the default action for myisamchk):

-c, --check　　　　 Check table for errors

-e, --extend-check　Check the table VERY throughly.　Only use this in

extreme cases as myisamchk should normally be able to

find out if the table is ok even without this switch

-F, --fast　　　　　Check only tables that haven't been closed properly

-C, --check-only-changed

Check only tables that have changed since last check

-f, --force　　　　 Restart with '-r' if there are any errors in the table.

States will be updated as with '--update-state'

-i, --information　 Print statistics information about table that is checked

-m, --medium-check　Faster than extend-check, but only finds 99.99% of

all errors.　Should be good enough for most cases

-U　--update-state　Mark tables as crashed if you find any errors

-T, --read-only　　 Don't mark table as checked

Repair options (When using '-r' or '-o')

-B, --backup　　　　Make a backup of the .MYD file as 'filename-time.BAK'

--correct-checksum　Correct checksum information for table.

-D, --data-file-length=#　Max length of data file (when recreating data

file when it's full)