- #!/bin/bash
- result=`/usr/bin/mysqladmin ping`
- expected='mysqld is alive'
- if [[ "$result" != "$expected" ]]
- then
- echo "It's dead - restart mysql"
- # email subject
- SUBJECT="[MYSQL ERROR] - Attempting to restart service"
- # Email To ?
- EMAIL="info@endyourif.com"
- # Email text/message
- EMAILMESSAGE="/tmp/emailmessage.txt"
- echo "$result was received"> $EMAILMESSAGE
- echo "when we were expected $expected" >>$EMAILMESSAGE
- # send an email using /bin/mail
- mail -s "$SUBJECT" "$EMAIL" < $EMAILMESSAGE
- sudo /etc/init.d/mysql restart
- fi
- #该片段来自于http://www.codesnippet.cn/detail/1305201512569.html
来源: http://www.codesnippet.cn/detail/1305201512569.html