mysql database gone away error 2006

Question

I am importing a sql file of 80 MB, and the mysql database goes away on error 2006. I increased the connect_timeout=2592000 and wait_timeout = 216000. What if anything else I need to import the sql file into the db.

It gets stuck at 18236 line. Can I start import from the 18237 line?

Appreciate all help.

score 2 · Answer 1 · edited May 29 '13 at 17:02

2

Solved the issue by

max_allowed = 16M

edited May 29 '13 at 17:02

Taryn

242,637
56
362
405

answered Jun 27 '11 at 12:16

X10nD

21,638
45
111
152

score 1 · Answer 2 · edited May 29 '13 at 17:02

1

Make a new file with the contents from line 18236 to END, also please check if any insert/update command are there in the beginning. If so, resolve and import the newest file.

edited May 29 '13 at 17:02

Taryn

242,637
56
362
405

answered Jun 27 '11 at 13:09

mahadeb

676
3
10

mysql database gone away error 2006

2 Answers2