mysql dba系统学习（16）mysql的mysqldump备份 - MySQL教程

                    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.

（编辑：应用网_镇江站长网）

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