Long Backup Problem (Reopening #4497)
Referring to #3822 and #4497, is there any other solution beside using large wait_timeout? Using that way give me too many sleep connections of inappropriate closed connections (I cannot control how dev people work). It seem "mysql.reconnect = On" in php.ini is not working either because mysqli.ping() is not working as expected, it cannot restore the lost connection due to wait timeout so the database backup query is not executed. If it is the only solution, I think it is better if backup script can set their own session of wait_timeout dynamically so it can use as large as it needs without giving sleep connections side effect. Otherwise, it seem that it is better if the database backup is done first before the file backup.