MySQL Forums
Forum List  »  Backup

Re: "mysqldump --single-transaction" and "--lock-tables"
Posted by: Sean Pringle
Date: February 20, 2008 08:20PM

Yes, --single-transaction disables --lock-tables. From "mysqldump --help":

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. Option
automatically turns off --lock-tables.

I agree that the manual should say this explicitly too.

Options: ReplyQuote

Written By
Re: "mysqldump --single-transaction" and "--lock-tables"
February 20, 2008 08:20PM

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.