Re: Re[2]: ERROR 2006 (HY000): MySQL server has gone away
Tried increasing the wait_timeout variable and restart the instance? http://dev.mysql.com/doc/refman/5.0/en/gone-away.html Let us know - 1) your my.ini settings. 2) the options you are giving while taking the dump. Regards, Uma On 11/17/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello Uma, Actually I did that about three time. I had it set for 32 megs to start and bumped it all the way up to 256 megs with the same results or no difference that I could tell. -- Best regards, mikeszmailto:[EMAIL PROTECTED]
ERROR 2006 (HY000): MySQL server has gone away
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]
Re: ERROR 2006 (HY000): MySQL server has gone away
can u please give us the command used to take dump 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]
Re: ERROR 2006 (HY000): MySQL server has gone away
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]