该
--lock-tables=false选项有效吗?
根据手册页,如果要转储InnoDB表,则可以使用以下
--single-transaction选项:
--lock-tables, -lLock all tables before dumping them. The tables are locked with READLOCAL to allow concurrent inserts in the case of MyISAM tables. Fortransactional tables such as InnoDB and BDB, --single-transaction isa much better option, because it does not need to lock the tables atall.
对于 innodb DB :
mysqldump --single-transaction=TRUE -u username -p DB



