mysqldump Error 2013： Lost connection to MySQL server during query when dumping table `tablename`

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
mysql> use mysql;
mysql> show global variables like '%timeout%';
+-----------------------------+----------+
| Variable_name               | Value    |
+-----------------------------+----------+
| connect_timeout             | 10       |
| delayed_insert_timeout      | 300      |
| innodb_flush_log_at_timeout | 1        |
| innodb_lock_wait_timeout    | 50       |
| innodb_rollback_on_timeout  | OFF      |
| interactive_timeout         | 28800    |
| lock_wait_timeout           | 31536000 |
| net_read_timeout            | 30       |
| net_write_timeout           | 60       |
| rpl_stop_slave_timeout      | 31536000 |
| slave_net_timeout           | 3600     |
| wait_timeout                | 28800    |
+-----------------------------+----------+
12 rows in set (0.00 sec)


将这些参数修改成：
wait_timeout：28800
interactive_timeout：28800
max_allowed_packet：1073741824
net_read_timeout：28800
net_write_timeout：28800

mysql> set global wait_timeout = 28800;
mysql> set global interactive_timeout = 28800;
mysql> set global max_allowed_packet = 1073741824;
mysql> set global net_read_timeout = 28800;
mysql> set global net_write_timeout = 28800;