MySQL: New var: default_mysqldump_options=--single-transaction

Version 1.60.4

Feature
Finished

New variable for both Mysql/MariaDB mysqldump calls: default_mysqldump_options=--single-transaction which is the internal default. If you set or add this to the directadmin.conf, it will override the internal default. This is meant to be the "base" set of optional variables. The extra_mysqldump_options (blank by default) is for addition variables that you with to add, to compliment the base set of options. We've added the --single-transaction option to avoid innodb locking issues. The --skip-lock-tables has not been added to ensure data consistency. ---- T24301

Interested to try DirectAdmin? Get a 30-day Free Trial!