Hi Mikesz,
Try increasing the "*max_allowed_packet*" value in *my.ini *and bounce the server. Explaination - if you send a query (specially via compressed packets) to the server that is larger than the max_allowed_packet, it drops the connection without providing a good error message. A packet too large is handled the same way as a bogus packet - there's no knowing if the connection is still good or what is going on, so the easiest way for the server is just to drop the connection and move along. The easy way to avoid this problem is to ensure that max_allowed_packet is set bigger in the mysqld server than in the client and that all clients uses the same value for max_allowed_packet. Let us know if this works for you. Thanks, Uma On 11/17/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hello & Greetings , > > I got about three blocks of errors like the following while trying to > import a table full of "attachments", mostly images. > > I am running on an XP configured with a WAMPSERVER so I am a little > unclear about why the no connection. I was importing directly using > the MySQL CLI. > > The Table is 360megs and this error occurred about three times in the > import. > > I even tried using bigdump to import it but soon after it started, it > did a binary dump to the screen and failed. > > ERROR 2006 (HY000): MySQL server has gone away > No connection. Trying to reconnect... > Connection id: 12 > Current database: worldrac_forum > > ERROR 2006 (HY000): MySQL server has gone away > No connection. Trying to reconnect... > Connection id: 13 > Current database: worldrac_forum > > ERROR 2006 (HY000): MySQL server has gone away > ERROR 2006 (HY000): MySQL server has gone away > No connection. Trying to reconnect... > Connection id: 14 > Current database: worldrac_forum > > > Any ideas how to troubeshoot this or what the problem might be? > > TIA > -- > Best regards, > mikesz mailto:[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
