`--single-transaction` equivalent for mysqlsh util.dumpSchema
0
votes
1
answer
83
views
My database is using InnoDB, and when using
mysqldump
I have the option to set --single-transaction
to avoid locking the tables while still having a consistent view of them.
I'm trying to switch over to the recommended [MySQL Shell util.dumpSchema
](https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-dump-instance-schema.html) , and I only see two options: consistent: true
and consistent: false
. The documentation for consistent: true
specifies that the tables will be locked for backup.
Is it possible to use util.dumpSchema
to dump in a single transaction via InnoDB in the same way? Or is this done automatically if the tables use InnoDB?
Asked by Nate Glenn
(103 rep)
Dec 14, 2024, 07:39 AM
Last activity: Dec 15, 2024, 01:27 PM
Last activity: Dec 15, 2024, 01:27 PM