mysqldump
— A Database Backup Program
298
Format
Option File
Description
Introduced
--ssl-
cipher=cipher_list [305]
ssl-cipher [305]
A list of allowable ciphers to use for SSL
encryption
--ssl-
key=file_name [305]
ssl-key [305]
The name of the SSL key file to use for
establishing a secure connection
--ssl-verify-server-
cert [305]
ssl-verify-server-
cert [305]
The server's Common Name value in its certificate
is verified against the host name used when
connecting to the server
--tab=path [305]
tab [305]
Produce tab-separated data files
--tables [305]
tables [305]
Override the --databases or -B option
--triggers [305]
triggers [305]
Dump triggers for each dumped table
--tz-utc [306]
tz-utc [306]
Add SET TIME_ZONE='+00:00' to the dump file
5.0.15
--
user=user_name [306]
user [306]
MySQL user name to use when connecting to
server
--verbose [306]
Verbose mode
--version [306]
Display version information and exit
--
where='where_condition' [306]
where [306]
Dump only rows selected by the given WHERE
condition
--xml [306]
xml [306]
Produce XML output
•
--help
[298]
,
-?
Display a help message and exit.
•
--add-drop-database
[298]
Add a
DROP DATABASE
statement before each
CREATE DATABASE
statement. This option is
typically used in conjunction with the
--all-databases
[298]
or
--databases
[299]
option
because no
CREATE DATABASE
statements are written unless one of those options is specified.
•
--add-drop-table
[298]
Add a
DROP TABLE
statement before each
CREATE TABLE
statement.
•
--add-locks
[298]
Surround each table dump with
LOCK TABLES
and
UNLOCK TABLES
statements. This results in
faster inserts when the dump file is reloaded. See
Section 8.3.2.1, “Speed of
INSERT
Statements”
.
•
--all-databases
[298]
,
-A
Dump all tables in all databases. This is the same as using the
--databases
[299]
option and
naming all the databases on the command line.
•
--allow-keywords
[298]
Permit creation of column names that are keywords. This works by prefixing each column name with
the table name.
•
--character-sets-dir=path
[298]
The directory where character sets are installed. See
Section 10.5, “Character Set Configuration”
.
•
--comments
[298]
,
-i
Содержание 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 ...