"mysqldump --single-transaction" and "--lock-tables"

[Vesselin Peev]

Hello,

Could someone please confirm authoritatively that the command

mysqldump --single-transaction database_file

actually turns off "--lock-tables" (one of the options contained in the "--opt" option that is implied)?

I've read the MySQL documentation where it says that --single-transaction and --lock-tables are mutually exclusive, but it could mean that once --lock-tables are specified implictly via --opt (or explicitly, of course), a later specification of --single-transaction is ignored, although this case would not be the most logical. I think it certainly isn't clear in the documentation what the case is, and that it should be stated somewhere explicitly, because it is crucial for backup consistency: --single-transaction would not produce a consistent backup for MyISAM tables (this is thankfully stated explicitly in the documentation).

Regards,
Vesselin.