Search This Blog

Wednesday, November 24, 2010

Common myisamchk options

myisamchk -mfq xxxx.MYI

  -m, --medium-check  Faster than extend-check, but only finds 99.99% of
                      all errors.  Should be good enough for most cases.

  -f, --force         Restart with '-r' if there are any errors in the table.
                      States will be updated as with '--update-state'.

  -q, --quick         Faster repair by not modifying the data file.
                      One can give a second '-q' to force myisamchk to
                      modify the original datafile in case of duplicate keys.
                      NOTE: Tables where the data file is currupted can't be
                      fixed with this option.

No comments:

Post a Comment