mysqldump

  -t, --no-create-info   Don't write table creation info（带-t 删表重建，不带-t则不删表重建。）

  -l, --lock-tables   Lock all tables for read. （锁表，默认是开启的。--lock-tables=false 不锁表）

  --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.
(设置整个导出的过程为一个事务，不使用锁)