MySQL server has gone away

inselfan · Post by **inselfan** » Mon Jun 23, 2008 12:17 pm

HolÃ¡ SQL-Pro's,

After NOT working with my mySQL-DB (and my Software) for a few hours, I get the messsage above. My question now is: How to "tell" mySQL or my aplication, NOT to let the server go away :-)

Can not find a solution in the docs. I know, it is something with "wait_timeout" but no Idea where/how.

Thanks for replies

Horst

Mark · Post by **Mark** » Mon Jun 23, 2008 1:10 pm

Hi Horst,

You have to set a MySQL environment variable for that. This is not Rev but MySQL. I have to do this only once in a while, so I'm not sure which variable it is, it should be something like WAITTIMEOUT.

Best,

Mark

inselfan · Post by **inselfan** » Tue Jun 24, 2008 8:17 am

HolÃ¡ Mark,

Yes, I also think, the sollution is "wait_timeout". But how/where to handle that?

best regards

Horst

Mark · Post by **Mark** » Tue Jun 24, 2008 9:53 am

Horst,

This is from a libary of mine:

Code: Select all

on sqlSetWaitTimeout theID,theInterval
  revExecuteSQL theID,"SET wait_timeout=" & theInterval & ";"
  return the result
end sqlSetWaitTimeout

Mark

inselfan · Post by **inselfan** » Wed Jun 25, 2008 8:18 am

HolÃ¡ Mark,

Thanks a lot for that. I'll try it and will see what happends.

All the best

Horst