mysqldump 使用–single-transaction

注意：innodb用 –single-transaction, myisam需要用 –lock-all-tables。 mysqldump -uroot -p'R00t,uHagt.0511'  -R --single-transaction --master-data=2 --all-database >slave.sql-R, --routines      Dump stored routines (functions and procedures).-R 选项,导出存储过程  --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所有的表在一个单独的transaction里,只能用于存储在支持多版本的(当前只支持InnoDB)存储引擎;dump不保证其他引擎的一致性。当--single-transaction dump运行时,为了确保正确的dump file(正确的表的内容和binary log的位置),没有其他链接使用下面的语句:ALTER TABLE, DROP TABLE, RENAME TABLE,TRUNCATE TABLE，因为一致的快照不是和它们脱离的选项自动关闭 --lock-tables