检查和修复mysql表：mysql table is marked as crashed and last (automatic?) repair failed
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 database
OR mysqlcheck --databases DB1
OR mysqlcheck --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-checkFaster 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.
页:
[1]