Dumping a Database as SQL Statements | 357

all-databases
Creates a dump of all databases on the server. This means you don’t have to supply any database names on the command line. We’ll show you an example of this later in this section.
create-options
Includes MySQL-specific information such as
ENGINE
and
CHARSET
in the table creation statements.
databases
Create a dump of the specified databases. This also ensures—even if you list only one database—that CREATE DATABASE
and
USE
statements are added to the output.
disable-keys
Tells MySQL to disable index updates during the
INSERT
operations for MyISAM
tables; the index is created after all the data has been loaded, which is more efficient.
extended-insert
Combines
INSERT
statements so that each statement inserts multiple table rows;
this helps speedup data restoration.
flush-logs
Flushes the server logs before dumping the data. This is useful in conjunction with incremental backups, as described later in The Binary Log.”
lock-tables
Locks all the tables in a database for the duration of the dump so that the dump is a consistent snapshot.
no-data
Dumps only the information necessary to recreate the database structure and leaves out the data the dump file will have no
INSERT
statements.
opt
This option, which is enabled by default from MySQL version 4.1 onwards, enables the options add-drop-table
, add-locks
, create-options
, disable-keys
, extended- insert, lock-tables
, quick, and set-charset
. You can disable all these by using the skip-opt option, or you can disable individual options by adding the prefix skip- in front of them for example, to disable add-locks
, you’d write skip-add-locks
However, they’re all sensible defaults that you’re likely to want inmost cases.
quick
Prevents mysqldump from buffering tables in memory before writing to the file this speeds up dumps from large tables.
result-file
Specifies the name of the output dump file, where the SQL commands are stored.
set-charset
Specifies the character set—for example, latin1
or utf8
—used by the database.

Download 4.24 Mb.

Share with your friends: