Re: Monitor Mysql Server

2001-12-17 Thread Jean-Luc Fontaine
Mike(mickalo)Blezien wrote: >Hello, > >Sorry for the OT,.. but I was hoping someone may suggest a script that can >monitor multiple mysql servers. We have two running and I would like to setup a >cron to check the servers once an hour or so to make sure it running and if not, >it would be capable

RE: Monitor Mysql Server

2001-12-15 Thread Ernie Hershey
Your cron line: 0 * * * * /home/you/mysqlcheck Or if it's in /etc/crontab 0 * * * * root /home/you/mysqlcheck And the script: #!/bin/sh # on error send e-mail to # adminmail="[EMAIL PROTECTED]" # or /usr/bin/safe_mysqld, etc. # restartCommand="/etc/rc.d/init.d/mysqld start" if [ ! "`ps au