On Sat, Apr 1, 2023 at 2:21 AM Benjamin Lees wrote:
>
> --lock-tables is enabled by default for mysqldump. --single-transaction
> offers a way to get a consistent dump without locking tables, but the tables
> have to support transactions (which InnoDB does and MyISAM does not). You
> should
--lock-tables is enabled by default for mysqldump. --single-transaction
offers a way to get a consistent dump without locking tables, but the
tables have to support transactions (which InnoDB does and MyISAM does
not). You should probably use --single-transaction if you can.
The mediawiki.org