mysql backup module does not report error

Submitted by Linulex on Tue, 11/18/2014 - 04:58

Hello,

This happened in the backup all databases backup. One of the databases had a very big table and produced this error:

mysqldump: Error 1317: Query execution was interrupted when dumping table free_testresult at row: 12198540

All database backups after that where 132 bytes, they where there, sort-off, a file with the database name was there, but the data was not backuped. I was able to fix the backup by enabling the option "Dump rows one at a time?". I know this error is the result of big tables, but that is not the point.

The point is that i configured the backup to mail only on failure and i didn't get an email.

Regards Jan

Status: 
Active

Comments

Submitted by andreychek on Tue, 11/18/2014 - 08:37

Howdy -- so just to verify -- if you go into Backup and Restore -> Backup Logs, does it list them as completing successfully? You can determine that by looking in the "OK" field.

Submitted by Linulex on Tue, 11/18/2014 - 08:56

hello,

where do i find backup and restore? this is webmin only, no cloudmin, no virtualmin.

this backup is done (via cron) with the "Backup Databases" button in the mysql webmin module.

regards Jan

Submitted by andreychek on Tue, 11/18/2014 - 22:22

Ah, I understand what you're saying now.

I'll do some work on testing and reproducing that issue. Thanks for the report!