mysqlcheck
— A Table Maintenance Program
289
make a symbolic link to
mysqlcheck
named
mysqlrepair
. If you invoke
mysqlrepair
, it repairs
tables.
The names shown in the following table can be used to change
mysqlcheck
default behavior.
Command
Meaning
mysqlrepair
The default option is
--repair
[292]
mysqlanalyze
The default option is
--analyze
[290]
mysqloptimize
The default option is
--optimize
[292]
mysqlcheck
supports the following options, which can be specified on the command line or in the
[mysqlcheck]
and
[client]
groups of an option file.
mysqlcheck
also supports the options for
processing option files described at
Section 4.2.3.4, “Command-Line Options that Affect Option-File
Handling”
.
Table 4.4.
mysqlcheck
Options
Format
Option File
Description
Introduced
--all-
databases [290]
all-
databases [290]
Check all tables in all databases
--all-in-1 [290]
all-in-1 [290]
Execute a single statement for each database that
names all the tables from that database
--analyze [290]
analyze [290]
Analyze the tables
--auto-
repair [291]
auto-
repair [291]
If a checked table is corrupted, automatically fix it
--character-sets-
dir=path [291]
character-sets-
dir [291]
The directory where character sets are installed
--check [291]
check [291]
Check the tables for errors
--check-only-
changed [291]
check-only-
changed [291]
Check only tables that have changed since the
last check
--check-
upgrade [291]
check-
upgrade [291]
Invoke CHECK TABLE with the FOR UPGRADE
option
5.0.19
--
compress [291]
compress [291]
Compress all information sent between the client
and the server
--
databases [291]
databases [291]
Process all tables in the named databases
--
debug[=debug_options] [291]
debug [291]
Write a debugging log
--default-
character-
set=charset_name [291]
default-character-
set [291]
Use charset_name as the default character set
--extended [291]
extended [291]
Check and repair tables
--fast [291]
fast [291]
Check only tables that have not been closed
properly
--force [291]
force [291]
Continue even if an SQL error occurs
--help [290]
Display help message and exit
--
host=host_name [291]
host [291]
Connect to the MySQL server on the given host
--medium-
check [291]
medium-
check [291]
Do a check that is faster than an --extended
operation
--optimize [292]
optimize [292]
Optimize the tables
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...