mysqldump
— A Database Backup Program
295
Table 4.5.
mysqldump
Options
Format
Option File
Description
Introduced
--add-drop-
database [298]
add-drop-
database [298]
Add a DROP DATABASE statement before each
CREATE DATABASE statement
--add-drop-
table [298]
add-drop-
table [298]
Add a DROP TABLE statement before each
CREATE TABLE statement
--add-
locks [298]
add-locks [298]
Surround each table dump with LOCK TABLES
and UNLOCK TABLES statements
--all-
databases [298]
all-
databases [298]
Dump all tables in all databases
--allow-
keywords [298]
allow-
keywords [298]
Allow creation of column names that are keywords
--
comments [298]
comments [298]
Add comments to the dump file
--compact [299]
compact [299]
Produce more compact output
--
compatible=name[,name,...] [299]
compatible [299]
Produce output that is more compatible with other
database systems or with older MySQL servers
--complete-
insert [299]
complete-
insert [299]
Use complete INSERT statements that include
column names
--create-
options [299]
create-
options [299]
Include all MySQL-specific table options in
CREATE TABLE statements
--
databases [299]
databases [299]
Dump several databases
--
debug[=debug_options] [299]
debug [299]
Write a debugging log
--debug-
info [299]
debug-info [299]
Print debugging information, memory and CPU
statistics when the program exits
5.0.32
--default-
character-
set=charset_name [300]
default-character-
set [300]
Use charset_name as the default character set
--delayed-
insert [300]
delayed-
insert [300]
Write INSERT DELAYED statements rather than
INSERT statements
--delete-master-
logs [300]
delete-master-
logs [300]
On a master replication server, delete the binary
logs after performing the dump operation
--disable-
keys [300]
disable-
keys [300]
For each table, surround the INSERT statements
with statements to disable and enable keys
--dump-
date [300]
dump-date [300]
Include dump date as "Dump completed on"
comment if --comments is given
5.0.52
--extended-
insert [300]
extended-
insert [300]
Use multiple-row INSERT syntax that include
several VALUES lists
--fields-enclosed-
by=string [300]
fields-enclosed-
by [300]
This option is used with the --tab option and has
the same meaning as the corresponding clause
for LOAD DATA INFILE
--fields-escaped-
by [300]
fields-escaped-
by [300]
This option is used with the --tab option and has
the same meaning as the corresponding clause
for LOAD DATA INFILE
--fields-optionally-
enclosed-
by=string [300]
fields-optionally-
enclosed-
by [300]
This option is used with the --tab option and has
the same meaning as the corresponding clause
for LOAD DATA INFILE
Содержание 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 ...