"lark" <hamzee@sbcdeglobalspam.net> wrote in
news:%HG_h.18$y_7.1@newssvr27.news.prodigy.net...

>>>> I'm encountering the Error #2006 when inserting data into a table
>>>> (ERROR 2006 (HY000): MySQL server has gone away). Each time after the
>>>> same amount of rows have been successfully added the mysql client
>>>> window shows me this error.

> here's what i recommend, increase the value of max_allowed_packet at the
> server level to 128M but leave the other two what they are. then increase
> the value of the same variable in all of your clients to 32M or even 64M
> and see what happens.

Yes, now it's working.

I set the max_allowed_packet parameter not only in the mysql-client window
by specifying:

set session max_allowed_packet=16000000;

but also in the my.ini config file.

Looks very much like this was the problem. Thanks for your help.
--
Matthias Wirtz - Karlsruhe, DE