MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

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":

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

I agree that the manual should say this explicitly too.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
"mysqldump --single-transaction" and "--lock-tables"
11156
Vesselin Peev
September 23, 2006 11:06AM
Re: "mysqldump --single-transaction" and "--lock-tables"
5325
Amit Kasher
August 07, 2007 11:15PM
Re: "mysqldump --single-transaction" and "--lock-tables"
5076
Dimitry Butko
November 02, 2007 01:48PM
Re: "mysqldump --single-transaction" and "--lock-tables"
3655
Sean Pringle
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.