mysql gone away error

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
yaron
Forum Contributor
Posts: 157
Joined: Fri Aug 22, 2003 8:40 am

mysql gone away error

Post 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
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

here

google (and Yahoo!) are your friends
yaron
Forum Contributor
Posts: 157
Joined: Fri Aug 22, 2003 8:40 am

Post 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?
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post 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
User avatar
ol4pr0
Forum Regular
Posts: 926
Joined: Thu Jan 08, 2004 11:22 am
Location: ecuador

Post by ol4pr0 »

Short and yet powerful answers :roll:
Post Reply