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
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