March 21st, 2014, 12:33 AM
Dumping by databases "error 2013" & mysqldump options
I'm doing remote backups using mysqldump from ZRM server to MySQL server. It usually works, but time to time it fails when it has to dump big databases. I get the error "Error 2013: Lost connection to MySQL server during query when dumping table".
If I do the dump by hand I must add "-q" option and the dump finishes fine (I've googled it), so I'd like to add that option to the mysqldump command on some servers, but I cannot find what parameter I have to modify ([url]http://wiki.zmanda.com/index.php/Backup_Set_Parameters[/url]).
So, anyone knows how to modify the dump command options?
Is there any other (better) way for solving this issue?
Many thanks in advance,
May 9th, 2014, 04:17 AM
Thank you all for your valuable information.