yogesh.kadalgikar

Hello All,

I am working on a project where we will be developing a Windows service that
checks the status to MySQL server whether it is running or not. I would like
to know if there is any provision provide d in MySQL so that I can execute
that command and collect the status. As I need to throw an exception say
that the server has gone down in case if it is not working. This should help
me in the networking too. As the service will be individually running on
different system.


Regards,
Yogesh


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql-win32@freebsd.csie.nctu.edu.tw

If MySQL server is not running you cannot use any MySQL commands to check
anything. You will probably need to use a Windows API call to check the
status of the service. That will probably only work on the same host. If
MySQL is on a remote host I suppose you could just try to establish a
connection and see if that succeeds. That would work locally too.

John B.

-----Original Message-----
From: Yogesh Kadalgikar [mailto:yogesh.kadalgikar@rakya.com]
Sent: Thursday, 16 October 2003 1:32 PM
To: Paul DuBois; Eric Weidner; win32@lists.mysql.com
Subject: Checking the status


Hello All,

I am working on a project where we will be developing a Windows service that
checks the status to MySQL server whether it is running or not. I would like
to know if there is any provision provide d in MySQL so that I can execute
that command and collect the status. As I need to throw an exception say
that the server has gone down in case if it is not working. This should help
me in the networking too. As the service will be individually running on
different system.


Regards,
Yogesh


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql-win32@freebsd.csie.nctu.edu.tw