mySQL disconnects

[Bob Sneidar]

Hi Mark. I’m a bit ahead of you on that one. I already ping before reconnecting to a database, but this will not ensure that the actual service is running on the server. Suppose the server is running but the database engine is crashed, or restarting for some reason, say a data backup for instance? 

What I need is a way to check for the availability of the database without actually running a query. My gut feeling is that there is not without invoking the dreaded 1 minute timeout, so the real question is, can I adjust the amount of time Livecode will wait before giving up? 

Bob


On Jan 31, 2014, at 13:42 , Mark Stuart <mfstuart at cox.net> wrote:

> Bob,
> If the OS environment is Windows, try shelling to a ping of the server to
> see if the server is up and running.
> Also, are there any MySQL command line functions that can be used also in a
> shell and reading the response. This may return a quicker result.
> 
> Regards,
> Mark
> 
> 
> 
> -----
> Regards,
> Mark Stuart
> -----------
> LC 4.6.4
> LC Community 6.1
> WinXP/7/8
> 32bit and 64bit
> --
> View this message in context: http://runtime-revolution.278305.n4.nabble.com/mySQL-disconnects-tp4675362p4675378.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode