Well, you could use a shell script to run "mysqladmin status".
I.e. this bash script:
#! /bin/bash
# mystatus.sh is really just a simple alias for a
# longer command.
# Usage: 'mystatus.sh PASSWORD'
# replace values of $my_hostname and $my_username if needed
my_hostname='localhost'
my_username='root'
my_password="${1}"
export my_hostname my_username my_password
# execute the command
/usr/local/mysql/bin/mysqladmin -h $my_hostname -u $my_username \
--password=$my_password status
# end of file
I tested this out with variables corresponding to my own system, I'm
running RH Linux with MySQL 3.23.46. You don't even have to replace the
values in the "variables" section of the script with your own, if your
MySQL server is on the localhost. The setup as is takes the password
from STDIN, so it's not stored anywhere (though I don't know how to
write a script that "hides" the password as you type it [yet]). I'm
sure that you could do a better script than this in Perl, which I don't
yet know.
I'm still learning how to write bash scripts (this is my second one that
does anything useful) so if this code is amateurish, sorry.
Erik
On Friday, January 4, 2002, at 06:52 AM, Sascha Kettner wrote:
> Hi!
>
> Short question: i want to have a perl watchdog telling me when executed
> if my sql-server is running and if anything is allright with it. So if i
> get any errormessage i can restart the server by remote. Has someone
> done this allready? Any hint?
>
> Thanks again and best regards
>
> Sascha Kettner
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <mysql-unsubscribe-
> [EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
