id
type
5
status
21
review version
1
cleanup version
0
pending deletion
0
created at
2026-01-31 16:36:42
updated at
2026-01-31 16:36:42
url
http://www.0937686468.com/2012/01/mysqldump-error-2013-lost-connection-to.html
url length
78
url crc
16394
url crc32
1864318986
location type
1
canonical status
10
canonical page id
domain id
domain tld
2211
domain parts
2
originating warc id
6553936
originating url
source type
11
page id
title
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table
excerpt
content
Try increasing the value of the max_allowed_packet system variable. Default size is 1MB but it sounds like you are exceeding this. To set this add max_allowed_packet=64M (replacing the 64M with whatever value you require) to your config file and restart the server or log into mysql client and issue SET GLOBAL max_allowed_packet=67108864 Note: Value in the config file can be followed by M, K to specifiy mb or kb but when using a SET command the value must be given as bytes or as an expression (eg you could specify a 64mb max_allowed_packet using SET GLOBAL max_allowed_packet=64*1024*1024). Hopefully this should resolve your problem. Sorry forgot to mention that mysqldump also has a max_allowed_packet option and you should try setting this in addition to the above when you run mysqldump. Just start mysqldump with a --max_allowed_packet= option. Source: forums.mysql.com
author
updated
1770460142
block type
0
extracted fields
104
extracted bits
title
full content
content was extracted heuristically
detected location
0
detected language
1 (English)
category id
-
index version
1
paywall score
0
spam phrases
0
text nonlatin
0
text cyrillic
0
text characters
705
text words
159
text unique words
92
text lines
1
text sentences
7
text paragraphs
1
text words per sentence
22
text matched phrases
0
text matched dictionaries
0
links self subdomains
0
links other subdomains
0
links other domains
0
links spam adult
0
links spam random
0
links spam expired
0
links ext activities
0
links ext ecommerce
0
links ext finance
0
links ext crypto
0
links ext booking
0
links ext news
0
links ext leaks
0
links ext ugc
9
links ext klim
0
links ext generic
0
image author
featured image