Difference between revisions of "Mysqldump --single-transaction"

From wikieduonline
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 17: Line 17:
  
 
  [[mysqldump --help]]
 
  [[mysqldump --help]]
 +
[[mysqldump --skip-lock-tables]]
 +
[[nice]]
  
 
== See also ==
 
== See also ==
 
* {{mysqldump}}
 
* {{mysqldump}}
 
* {{InnoDB}}
 
* {{InnoDB}}
 +
 +
[[Category:MySQL]]

Latest revision as of 06:34, 9 June 2024


 --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. While a
                     --single-transaction dump is in process, to ensure a
                     valid dump file (correct table contents and binary log
                     position), no other connection should use the following
                     statements: ALTER TABLE, DROP TABLE, RENAME TABLE,
                     TRUNCATE TABLE, as consistent snapshot is not isolated
                     from them. Option automatically turns off --lock-tables.


mysqldump --help
mysqldump --skip-lock-tables
nice

See also[edit]

Advertising: