mysqldump Error 2013: Lost connection to MySQL server

<<Back to MySQL & MariaDB Main Page

mysqldump Error 2013: Lost connection to MySQL server during query when dumping table 'string' at row

Solution: Increase the value of

net_read_timeout = 120

net_write_timeout = 900

and

max_allowed_packet=256 or even 1GB and try mysqldump again.

Default value for me was

net_read_timeout            60

net_write_timeout           60

max_allowed_packet      4194304

Changing the value as mentioned below solved my Issue.

net_read_timeout = 120

net_write_timeout = 900

max_allowed_packet=256  MB

You can Change the value of These variables either in my.cnf file which requires restart of the MYSQL sever

or

Just session or Global Level using set command

set global net_write_timeout=900;

Query OK, 0 rows affected (0.00 sec)

set global net_read_timeout=120;

Query OK, 0 rows affected (0.00 sec)

set global max_allowed_packet=268435456;

Query OK, 0 rows affected (0.00 sec)