mysqlcheck
— A Table Maintenance Program
292
Do a check that is faster than an
--extended
[291]
operation. This finds only 99.99% of all errors,
which should be good enough in most cases.
•
--optimize
[292]
,
-o
Optimize the tables.
•
--password[=password]
[292]
,
-p[password]
The password to use when connecting to the server. If you use the short option form (
-p
), you
cannot have a space between the option and the password. If you omit the
password
value
following the
--password
[292]
or
-p
option on the command line,
mysqlcheck
prompts for one.
Specifying a password on the command line should be considered insecure. See
Section 6.1.2.1,
“End-User Guidelines for Password Security”
. You can use an option file to avoid giving the
password on the command line.
•
--pipe
[292]
,
-W
On Windows, connect to the server using a named pipe. This option applies only if the server
supports named-pipe connections.
•
--port=port_num
[292]
,
-P port_num
The TCP/IP port number to use for the connection.
•
--protocol={TCP|SOCKET|PIPE|MEMORY}
[292]
The connection protocol to use for connecting to the server. It is useful when the other connection
parameters normally would cause a protocol to be used other than the one you want. For details on
the permissible values, see
Section 4.2.2, “Connecting to the MySQL Server”
.
•
--quick
[292]
,
-q
If you are using this option to check tables, it prevents the check from scanning the rows to check for
incorrect links. This is the fastest check method.
If you are using this option to repair tables, it tries to repair only the index tree. This is the fastest
repair method.
•
--repair
[292]
,
-r
Perform a repair that can fix almost anything except unique keys that are not unique.
•
--silent
[292]
,
-s
Silent mode. Print only error messages.
•
--socket=path
[292]
,
-S path
For connections to
localhost
, the Unix socket file to use, or, on Windows, the name of the named
pipe to use.
•
--ssl*
Options that begin with
--ssl
[607]
specify whether to connect to the server using SSL and
indicate where to find SSL keys and certificates. See
Section 6.3.6.4, “SSL Command Options”
.
•
--tables
[292]
Override the
--databases
[291]
or
-B
option. All name arguments following the option are
regarded as table names.
Содержание 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 ...