![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196311.webp)
mysqlcheck
— A Table Maintenance Program
291
•
--auto-repair
[291]
If a checked table is corrupted, automatically fix it. Any necessary repairs are done after all tables
have been checked.
•
--character-sets-dir=path
[291]
The directory where character sets are installed. See
Section 10.5, “Character Set Configuration”
.
•
--check
[291]
,
-c
Check the tables for errors. This is the default operation.
•
--check-only-changed
[291]
,
-C
Check only tables that have changed since the last check or that have not been closed properly.
•
--check-upgrade
[291]
,
-g
Invoke
CHECK TABLE
with the
FOR UPGRADE
option to check tables for incompatibilities with the
current version of the server. This option was added in MySQL 5.0.19.
•
--compress
[291]
Compress all information sent between the client and the server if both support compression.
•
--databases
[291]
,
-B
Process all tables in the named databases. Normally,
mysqlcheck
treats the first name argument
on the command line as a database name and following names as table names. With this option, it
treats all name arguments as database names.
•
--debug[=debug_options]
[291]
,
-# [debug_options]
Write a debugging log. A typical
debug_options
string is
'd:t:o,file_name'
. The default is
'd:t:o'
.
•
--default-character-set=charset_name
[291]
Use
charset_name
as the default character set. See
Section 10.5, “Character Set Configuration”
.
•
--extended
[291]
,
-e
If you are using this option to check tables, it ensures that they are 100% consistent but takes a long
time.
If you are using this option to repair tables, it runs an extended repair that may not only take a long
time to execute, but may produce a lot of garbage rows also!
•
--fast
[291]
,
-F
Check only tables that have not been closed properly.
•
--force
[291]
,
-f
Continue even if an SQL error occurs.
•
--host=host_name
[291]
,
-h host_name
Connect to the MySQL server on the given host.
•
--medium-check
[291]
,
-m
Содержание 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 ...