Page 1 of 1

mysql gone away error

Posted: Tue Feb 03, 2004 11:49 am
by yaron
Hello all,
I'm trying to enter mysql db a long text (input from a file).
I've done this many times before but now I get this error when I try to store large content: MySQL server has gone away.

I've read somewhere that there is a problem with content above 1MB
is this true?is there a way to overcome this?

Thank you all

Posted: Tue Feb 03, 2004 11:50 am
by malcolmboston
here

google (and Yahoo!) are your friends

Posted: Tue Feb 03, 2004 12:09 pm
by yaron
Ok. I understood I have to change the variable called:
max_allowed_packet to it's max capacity (16MB in my system).

I can't seem to to find where exatcly I should change this parameter.
Where its location?

Posted: Tue Feb 03, 2004 12:11 pm
by malcolmboston
lots of answers here

get in the habit of searching before posting as 90% of the time the problem will be solved that way

hope this helps

Posted: Tue Feb 03, 2004 1:48 pm
by ol4pr0
Short and yet powerful answers :roll: