MySQL Forums
Forum List  »  Backup

"mysqldump --single-transaction" and "--lock-tables"
Posted by: Vesselin Peev
Date: September 23, 2006 11:06AM


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).


Options: ReplyQuote

Written By
"mysqldump --single-transaction" and "--lock-tables"
September 23, 2006 11:06AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.