Data consistency

Hi,
what do you suggest to setup to ensure consistency for mysql innodb db dumps?
Is there any pre or post script to suggest?


Are the default configurations correct for this purpose?

Thanks

Hi Jake_B,

Yes, the --lock-tables option guarantees consistency of the exported data at the database level. However, the database goes into read-only mode at the time of the dump. If your database uses innoDB based tables, it is more preferable to use the --single-transaction option and disable the --lock-tables option.

You can find more details at the “Transactional Options” section at: https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html