开发者

mysql database gone away error 2006

开发者 https://www.devze.com 2023-03-15 12:03 出处:网络
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

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 开发者_StackOverflow中文版line. Can I start import from the 18237 line?

Appreciate all help.


Solved the issue by

max_allowed = 16M


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消