第一種方法：利用mysql命令查看
MySQL 內建直接看 status 就可以看到系統常見訊息, 如下述范例:
檢查mysql是否成功啟動
#!/bin/bash#mysql checkPORT="0"PORT=`netstat -lnt | grep 3306 | wc -l `echo $PORTif [ $PORT -eq 1 ] thenecho "mysql is running"elseecho "mysql is not running"echo "progrome reeady to start mysql "sudo service mysql start./check_mysql.shfi
檢測 MySQL 是否宕掉，如果宕掉則啟動
如果你的 MySQL 經常宕機，可以用這個腳本來實現宕機后自動啟動，把它加到 crontab 里執行即可。
詳細介紹請看 http://www.codeproject.com/Articles/988967/Mysql-Uptime-Check-Script
#!/bin/bash result=`/usr/bin/mysqladmin ping`expected='mysqld is alive' if [[ "$result" != "$expected" ]]thenecho "It's dead - restart mysql" # email subjectSUBJECT="[MYSQL ERROR] - Attempting to restart service" # Email To ?EMAIL="info@endyourif.com" # Email text/messageEMAILMESSAGE="/tmp/emailmessage.txt"echo "$result was received"> $EMAILMESSAGEecho "when we were expected $expected" >>$EMAILMESSAGE# send an email using /bin/mailmail -s "$SUBJECT" "$EMAIL" < $EMAILMESSAGE sudo /etc/init.d/mysql restartfi
Mysql bat啟動和關閉服務bat版
@echo offfor /f "skip=3 tokens=4" %%i in ('sc query mysql') do set "zt=%%i" &goto :next:nextif /i "%zt%"=="RUNNING" (echo 已經發現該服務在運行，正在已經關閉服務net stop mysql) else (echo 該服務現在處理停止狀態，正在現在開啟服務net start mysql)exitpause經測試有時候不是很好用。
新聞熱點
疑難解答
