how to set --single-transaction for the nightly database backup

**Cool** · Apr 7th 2016

hi,
i´ve to set the "--single-transaction" option for the nightly imscp database backup.
where is this to set?

the reason is to the error:
iMSCP::Database::mysql::dumpdb: mysqldump: Got error:1016: Can't open
file: './wcr/teststorestore_delivery.frm' (errno: 24 -Too many open
files) when using LOCK TABLES

**Nuxwin** · Apr 7th 2016

@Cool

Bad idea. Why? See:

http://youtrack.i-mscp.net/issue/IP-446
http://dev.mysql.com/doc/refma…qldump_single-transaction

Better is to solve the real error. You must raise open file limit.

About your question

We run mysqldump from here: https://github.com/i-MSCP/imsc…CP/Database/mysql.pm#L298
I don't know if you can set the --single-transaction in a conffile (mysqldump section).

how to set --single-transaction for the nightly database backup

Share

Daily visitors