mysqldump
— A Database Backup Program
297
Format
Option File
Description
Introduced
--
password[=password] [303]
password [303]
The password to use when connecting to the
server
--pipe [303]
On Windows, connect to server using a named
pipe
--
port=port_num [303]
port [303]
The TCP/IP port number to use for the connection
--quick [304]
quick [304]
Retrieve rows for a table from the server a row at
a time
--quote-
names [304]
quote-
names [304]
Quote identifiers within backtick characters
--result-
file=file [304]
result-file [304]
Direct output to a given file
--routines [304]
routines [304]
Dump stored routines (procedures and functions)
from the dumped databases
5.0.13
--set-
charset [304]
set-
charset [304]
Add SET NAMES default_character_set to output
--single-
transaction [304]
single-
transaction [304]
This option issues a BEGIN SQL statement before
dumping data from the server
--skip-add-drop-
table [298]
skip-add-drop-
table [298]
Do not add a DROP TABLE statement before
each CREATE TABLE statement
--skip-add-
locks [298]
skip-add-
locks [298]
Do not add locks
--skip-
comments [305]
skip-
comments [305]
Do not add comments to the dump file
--skip-
compact [299]
skip-
compact [299]
Do not produce more compact output
--skip-disable-
keys [300]
skip-disable-
keys [300]
Do not disable keys
--skip-extended-
insert [300]
skip-extended-
insert [300]
Turn off extended-insert
--skip-opt [305]
skip-opt [305]
Turn off the options set by --opt
--skip-
quick [304]
skip-quick [304]
Do not retrieve rows for a table from the server a
row at a time
--skip-quote-
names [304]
skip-quote-
names [304]
Do not quote identifiers
--skip-set-
charset [304]
skip-set-
charset [304]
Suppress the SET NAMES statement
--skip-
triggers [305]
skip-
triggers [305]
Do not dump triggers
5.0.11
--skip-tz-
utc [306]
skip-tz-utc [306]
Turn off tz-utc
5.0.15
--ssl-
ca=file_name [305]
ssl-ca [305]
The path to a file that contains a list of trusted SSL
CAs
--ssl-
capath=dir_name [305]
ssl-capath [305]
The path to a directory that contains trusted SSL
CA certificates in PEM format
--ssl-
cert=file_name [305]
ssl-cert [305]
The name of the SSL certificate file to use for
establishing a secure connection
Содержание 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 ...