I see one conflict that could be causing your "lost connection" message -
you are specifying a 1 GB "max_allowed_packet" for the client, but the
server is configured to only support 64 MB.
You should adjust the "max_allowed_packet = 64M" setting on the server to
match or exceed what you specify on
Unfortunately the additional parameters didn't solve my problem. But
thanks for your response!
ssh [EMAIL PROTECTED] \
"mysqldump -u XYZ --verbose --password=XYZ --quick
--single-transaction --net_buffer_length=1G --max_allowed_packet=1G
dbmail | /bin/gzip" \
> /Backup/HD-Save/
Hiya,
I was backing up a 95GB InnoDB database and forever had problems. It ended up
working and I never really worked out exactly what the cause was... but try
using the following:
--opt (does --quick + extended-insert + others)
--net_buffer_length=1G (set this to whatever you want, 1G is the l
