《Mysql應(yīng)用檢查mysql是否成功啟動(dòng)的方法(bat+bash)》要點(diǎn)：
本文介紹了Mysql應(yīng)用檢查mysql是否成功啟動(dòng)的方法(bat+bash)，希望對(duì)您有用。如果有疑問(wèn)，可以聯(lián)系我們。
MYSQL學(xué)習(xí)很多朋友更喜歡windows下面的可以參考下面的代碼
MYSQL學(xué)習(xí)第一種方法：也比較普遍的方法,包括rsync、serv_u等都可以,通過(guò)查找進(jìn)程中的exe文件,例如mysql就是mysqld.exe
MYSQL學(xué)習(xí)
@echo off
for /f "usebackq" %%i in (`"tasklist|find /c "mysqld.exe""`) do (
set chkstat=%%i
)
if %chkstat% == 0 (
net start mysql
echo ================ >> %date:~0,10%.log
echo %date% %time% check mysql service stop >> %date:~0,10%.log
echo restart mysql service! >> %date:~0,10%.log
echo ================ >> %date:~0,10%.log
)
MYSQL學(xué)習(xí)第二種方法：
MYSQL學(xué)習(xí)
@echo off
for /f "skip=3 tokens=4" %%i in ('sc query mysql') do set "zt=%%i" &goto :next
:next
if /i "%zt%"=="RUNNING" (
echo 已經(jīng)發(fā)現(xiàn)該服務(wù)在運(yùn)行,正在已經(jīng)關(guān)閉服務(wù)
net stop mysql
) else (
echo 該服務(wù)現(xiàn)在處理停止?fàn)顟B(tài),正在現(xiàn)在開(kāi)啟服務(wù)
net start mysql
)
exit
pause
MYSQL學(xué)習(xí)linux系統(tǒng)中通過(guò)shell命令實(shí)現(xiàn)
MYSQL學(xué)習(xí)檢測(cè) MySQL 是否宕掉,如果宕掉則啟動(dòng)
MYSQL學(xué)習(xí)如果你的 MySQL 經(jīng)常宕機(jī),可以用這個(gè)腳本來(lái)實(shí)現(xiàn)宕機(jī)后自動(dòng)啟動(dòng),把它加到 crontab 里執(zhí)行即可.
詳細(xì)介紹請(qǐng)看 http://www.codeproject.com/Articles/988967/Mysql-Uptime-Check-Script
MYSQL學(xué)習(xí)
#!/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
MYSQL學(xué)習(xí)方法二、
MYSQL學(xué)習(xí)
#!/bin/bash
#mysql check
PORT="0"
PORT=`netstat -lnt | grep 3306 | wc -l `
echo $PORT
if [ $PORT -eq 1 ]
then
echo "mysql is running"
else
echo "mysql is not running"
echo "progrome reeady to start mysql "
sudo service mysql start
./check_mysql.sh
fi
轉(zhuǎn)載請(qǐng)注明本頁(yè)網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/5994.html
