ERROR 2006 (HY000) MySQL server has gone away
Hi, I am getting crazy about this :(. I have huge database (about 2GB dump), where only one table with longblob column is big. I have to transfer the database to another PC. So, I mysqldump it (it's OK), but any time I try to load the dump I get the error. So, I was Googling and Googling. Whatever I found it was talking about max-allowed-packet setting. So I tuned my mysqldump - 5M setting was OK as the smallest number. But still I am not able to load the dump, although I have max_allowed_packet=64M in my my.ini file (I am running Win 8 64bit). I increased other values in the ini file as well. Now I am lost .... :( Please, could anybody help me to identify and solve the problem?
Marek
Subject
Views
Written By
Posted
ERROR 2006 (HY000) MySQL server has gone away
37546
December 05, 2013 04:26AM
12840
December 06, 2013 11:52PM
5367
December 07, 2013 02:27AM
4671
December 07, 2013 11:27PM
4981
December 08, 2013 02:01AM
6397
December 08, 2013 11:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.