Lost Connection during query from Navicat

[gsaunders]

I am using Navicat to manage mySQL and I regulary get "Lost connection during query". I have to basically reconnect.

Here is where their tech support point user to:
http://support.navicat.com/index.php?_a=knowledgebase&_j=questiondetails&_i=107

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

Could anyone from Jod shed any light on this. Apperently this is a regular issue with many hosts.

Thanks

 

[tanmaya]

These programs rely on persitant connections to MySQL. Such connections are mostly timebound in shared hosting. Unless MySQL allows a seperate variable for timeout ( or a diff protocol) to handle DB management, it will remain the same.

Edit - your navicat URL isnt working.

 

[gsaunders]

These programs rely on persitant connections to MySQL. Such connections are mostly timebound in shared hosting. Unless MySQL allows a seperate variable for timeout ( or a diff protocol) to handle DB management, it will remain the same.

Edit - your navicat URL isnt working.

Hmmm... the link works or me. Regardless here is what that link says:

2013 - Lost Connection to MySQL Server during query
The error you received "Error: 2013 (CR_SERVER_LOST) Message: Lost connection to MySQL server during query " is returned by MySQL and is due to server variables settings.

For more details on how to set the server variable to avoid this error, please refer to MySQL Manaul:
http://dev.mysql.com/doc/mysql/en/Gone_away.html

 

[tanmaya]

I still cant access it in IE or FF, even their homepage.
Anways, the answer still applies.
Check if it provides some auto-reconnect or timeout related option.

 

[gsaunders]

I still cant access it in IE or FF, even their homepage.
Anways, the answer still applies.
Check if it provides some auto-reconnect or timeout related option.

I found an auto reconnect every x seconds feature that I turned on. It definitely helps, but I still see it every so often, but nowhere near what is was. I may lower the reconnect time limit.

It is much better now. Thanks.

 

[skypanther]

I don't use Navicat but instead an older version of MySQL-Front (the old freeware version not the newer paid version). It also occasionally times out. But, simply repeating whatever I was doing reconnects it to the server. For example, I enter new data in a field and tab to the next record to update the db; get the error; hit tab again and this time it updates.

The only bummer is that when the error happens, MySQL-Front plays the Windows error sound. I'm usually cranking tunes fairly loud so that "ding" is really loud! It sure wakes me up!

Tim