Sample Header Ad - 728x90

`--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