mysql dba体系进修（16）mysql的mysqldump备份

mysqldump备份数据库

-B, --databases     Dump several databases. Note the difference in usage; in

                    this case no tables are given. All name arguments are

                    regarded as database names. 'USE db_name;' will be

                    included in the output.

-e, --extended-insert

                    Use multiple-row INSERT syntax that include several

                    VALUES lists.  多行插入数据

   为了保证数据的一致性，我们要把表锁起来在dump

-F, --flush-logs    Flush logs file in server before starting dump. Note that

                    if you dump many databases at once (using the option

                    --databases= or --all-databases), the logs will be

                    flushed for each database dumped. The exception is when

                    using --lock-all-tables or --master-data: in this case

                    the logs will be flushed only once, corresponding to the

                    moment all tables are locked. So if you want your dump

                    and the log flush to happen at the same exact moment you

                    should use --lock-all-tables or --master-data with

                    --flush-logs.              

-x, --lock-all-tables

                    Locks all tables across all databases. This is achieved

                    by taking a global read lock for the duration of the

                    whole dump. Automatically turns --single-transaction and

                    --lock-tables off.

-l, --lock-tables   Lock all tables for read.

--master-data[=#]   This causes the binary log position and filename to be

                    appended to the output. If equal to 1, will print it as a

                    CHANGE MASTER command; if equal to 2, that command will

                    be prefixed with a comment symbol. This option will turn

                    --lock-all-tables on, unless --single-transaction is

                    specified too (in which case a global read lock is only

                    taken a short time at the beginning of the dump; don't

                    forget to read about --single-transaction below). In all

                    cases, any action on logs will happen at the exact moment

                    of the dump. Option automatically turns --lock-tables

                    off.

-t, --no-create-info

                    Don't write table creation info.

-d, --no-data       No row information.

-N, --no-set-names  Suppress the SET NAMES statement

--opt               Same as --add-drop-table, --add-locks, --create-options,

                    --quick, --extended-insert, --lock-tables, --set-charset,

                    and --disable-keys. Enabled by default, disable with

                    --skip-opt.

-q, --quick         Don't buffer query, dump directly to stdout.   不缓存

查看本栏目更多精彩内容：http://www.bianceng.cn/database/MySQL/

 -R, --routines      Dump stored routines (functions and procedures).

 --single-transaction

                    Creates a consistent snapshot by dumping all tables in a

                    single transaction. Works ONLY for tables stored in

                    storage engines which support multiversioning (currently

                    only InnoDB does); the dump is NOT guaranteed to be

                    consistent for other storage engines. While a

                    --single-transaction dump is in process, to ensure a

                    valid dump file (correct table contents and binary log

                    position), no other connection should use the following

                    statements: ALTER TABLE, DROP TABLE, RENAME TABLE,

                    TRUNCATE TABLE, as consistent snapshot is not isolated

                    from them. Option automatically turns off --lock-tables.

--dump-date         Put a dump date to the end of the output.

--skip-opt          Disable --opt. Disables --add-drop-table, --add-locks,

                    --create-options, --quick, --extended-insert,

                    --lock-tables, --set-charset, and --disable-keys.

（编辑：淮北站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!