Oracle 5.0, Reference Manual

Page: 323 / 3232

mysqldump
— A Database Backup Program
303
•
--no-autocommit
[303]
Enclose the
INSERT
statements for each dumped table within
SET autocommit = 0
and
COMMIT
statements.
•
--no-create-db
[303] ,
-n
This option suppresses the
CREATE DATABASE
statements that are otherwise included in the output
if the
--databases
[299] or
--all-databases
[298] option is given.
•
--no-create-info
[303] ,
-t
Do not write
CREATE TABLE
statements that re-create each dumped table.
•
--no-data
[303] ,
-d
Do not write any table row information (that is, do not dump table contents). This is useful if you want
to dump only the
CREATE TABLE
statement for the table (for example, to create an empty copy of
the table by loading the dump file).
•
--no-set-names
[303] ,
-N
This has the same effect as
--skip-set-charset
[304] .
•
--opt
[303]
This option is shorthand. It is the same as specifying
--add-drop-table
[298]
--add-
locks
[298]
--create-options
[299]
--disable-keys
[300]
--extended-
insert
[300]
--lock-tables
[301]
--quick
[304]
--set-charset
[304] . It should
give you a fast dump operation and produce a dump file that can be reloaded into a MySQL server
quickly.
The
--opt
[303] option is enabled by default. Use
--skip-opt
[305] to disable it. See the
discussion at the beginning of this section for information about selectively enabling or disabling a
subset of the options affected by
--opt
[303] .
•
--order-by-primary
[303]
Dump each table's rows sorted by its primary key, or by its first unique index, if such an index exists.
This is useful when dumping a
MyISAM
table to be loaded into an
InnoDB
table, but will make the
dump operation take considerably longer.
•
--password[=password]
[303] ,
-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
[303] or
-p
option on the command line,
mysqldump
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
[303] ,
-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
[303] ,
-P port_num
The TCP/IP port number to use for the connection.
•
--protocol={TCP|SOCKET|PIPE|MEMORY}
[303]