PDA

View Full Version : Dumping by databases "error 2013" & mysqldump options



pelacables
March 21st, 2014, 01:33 AM
Hello,

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 (http://wiki.zmanda.com/index.php/Backup_Set_Parameters).

So, anyone knows how to modify the dump command options?
Is there any other (better) way for solving this issue?


Many thanks in advance,
Arnau

port12345
May 9th, 2014, 05:17 AM
Thank you all for your valuable information.