mysqldump Error 2013: Lost connection to MySQL server

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)