检查和修复mysql表：mysql table is marked as crashed and last (automatic?) repair failed

qianqianling

　　This program can be used to CHECK (-c,-m,-C), REPAIR (-r), ANALYZE (-a)
　　or OPTIMIZE (-o) tables. Some of the options (like -e or -q) can be
　　used at the same time. Not all options are supported by all storage engines.
　　Please consult the MySQL manual for latest information about the
　　above. The options -c,-r,-a and -o are exclusive to each other, which
　　means that the last option will be used, if several was specified.
　　The option -c will be used by default, if none was specified. You
　　can change the default behavior by making a symbolic link, or

　　copying this file somewhere with another name, the>　　mysqlrepair:   The default option will be -r
　　mysqlanalyze:  The default option will be -a
　　mysqloptimize: The default option will be -o
　　Usage: mysqlcheck [OPTIONS] database [tables]
　　OR     mysqlcheck [OPTIONS] --databases DB1 [DB2 DB3...]
　　OR     mysqlcheck [OPTIONS] --all-databases
　　--print-defaults        Print the program argument list and exit
　　--no-defaults           Don't read default options from any options file
　　--defaults-file=#       Only read default options from the given file #
　　--defaults-extra-file=# Read this file after the global files are read
　　-A, --all-databases Check all the databases. This will be same as
　　--databases with all databases selected.
　　-a, --analyze       Analyze given tables.
　　-1, --all-in-1      Instead of issuing one query for each table, use one
　　query per database, naming all tables in the database in
　　a comma-separated list.
　　--auto-repair       If a checked table is corrupted, automatically fix it.
　　Repairing will be done after all tables have been
　　checked, if corrupted ones were found.
　　--character-sets-dir=name
　　Directory where character sets are.
　　-c, --check         Check table for errors.
　　-C, --check-only-changed
　　Check only tables that have changed since last check or
　　haven't been closed properly.
　　-g, --check-upgrade Check tables for version-dependent changes. May be used
　　with --auto-repair to correct tables requiring
　　version-dependent updates.
　　--compress          Use compression in server/client protocol.
　　-B, --databases     To check several databases. Note the difference in usage;
　　In this case no tables are given. All name arguments are
　　regarded as databasenames.
　　-#, --debug[=#]     This is a non-debug version. Catch this and exit.
　　--default-character-set=name
　　Set the default character set.
　　-F, --fast          Check only tables that haven't been closed properly.
　　-f, --force         Continue even if we get an sql-error.
　　-e, --extended      If you are using this option with CHECK TABLE, it will
　　ensure that the table is 100 percent consistent, but will
　　take a long time. If you are using this option with
　　REPAIR TABLE, it will force using old slow repair with
　　keycache method, instead of much faster repair by
　　sorting.
　　-?, --help          Display this help message and exit.
　　-h, --host=name     Connect to host.
　　-m, --medium-check  Faster than extended-check, but only finds 99.99 percent
　　of all errors. Should be good enough for most cases.
　　-o, --optimize      Optimize table.
　　-p, --password[=name]
　　Password to use when connecting to server. If password is
　　not given it's solicited on the tty.
　　-P, --port=#        Port number to use for connection.
　　--protocol=name     The protocol of connection (tcp,socket,pipe,memory).
　　-q, --quick         If you are using this option with CHECK TABLE, it
　　prevents the check from scanning the rows to check for
　　wrong links. This is the fastest check. If you are using
　　this option with REPAIR TABLE, it will try to repair only
　　the index tree. This is the fastest repair method for a
　　table.
　　-r, --repair        Can fix almost anything except unique keys that aren't
　　unique.
　　-s, --silent        Print only error messages.
　　-S, --socket=name   Socket file to use for connection.
　　--tables            Overrides option --databases (-B).
　　--use-frm           When used with REPAIR, get table structure from .frm
　　file, so the table can be repaired even if .MYI header is
　　corrupted.
　　-u, --user=name     User for login if not current user.
　　-v, --verbose       Print info about the various stages.
　　-V, --version       Output version information and exit.