LiveCode Forums.

Posted: **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

Posted: **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

Posted: **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

Posted: **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

Posted: **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

LiveCode Forums.

MySQL server has gone away

MySQL server has gone away