Maximum statement execution time exceeded when dumping table

#1

Hi, I have a little problem,
Is this problem on my server side (ubutuntu 18)? or is there something to configure on the machine (windows machine) where sqlbackupandftp is running on?

Kind regards…

9-5-2020 10:27:27 [Error] Failed to backup “******” database with “Full” backup type: mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Error 3024: Query execution was interrupted, maximum statement execution time exceeded when dumping table ****** at row: 266144
mysqldump: Error 3024: Query execution was interrupted, maximum statement execution time exceeded when dumping table ******* at row: 39636

#2

Hi jeboem,

Thank you for the details.

We have checked the issue and can confirm it is on the MySQL Server side. It is recommended to change the value of the global variable max_execution_time. Please find more details on the web.

Sorry for the inconvenience.