下面一起來了解下MySQL起停腳本操作方法，相信大家看完肯定會(huì)受益匪淺，文字在精不在多，希望MySQL起停腳本操作方法這篇短內(nèi)容是你想要的。

網(wǎng)站建設(shè)公司,為您提供網(wǎng)站建設(shè),網(wǎng)站制作,網(wǎng)頁設(shè)計(jì)及定制網(wǎng)站建設(shè)服務(wù),專注于企業(yè)網(wǎng)站制作,高端網(wǎng)頁制作,對(duì)報(bào)廢汽車回收等多個(gè)行業(yè)擁有豐富的網(wǎng)站建設(shè)經(jīng)驗(yàn)的網(wǎng)站建設(shè)公司。專業(yè)網(wǎng)站設(shè)計(jì),網(wǎng)站優(yōu)化推廣哪家好,專業(yè)seo優(yōu)化優(yōu)化,H5建站,響應(yīng)式網(wǎng)站。

#!/bin/bash
#

mysqld     This shell script takes care of starting and stopping

the MySQL subsystem (mysqld).

#

chkconfig: 2345 78 36

description:  MySQL database server.

processname: mysqld

config: /data/mysql/mysql3306/data/my3306.cnf

pidfile: /data/mysql/mysql3306/data/mysql3306.pid

Source function library.

. /etc/rc.d/init.d/functions

Source networking configuration.

. /etc/sysconfig/network
prog="MySQL"

extract value of a MySQL option from config files

Usage: get_mysql_option SECTION VARNAME DEFAULT

result is returned in $result

We use my_print_defaults which prints all options from multiple files,

with the more specific ones later; hence take the last match.

get_mysql_option(){
result=/usr/local/mysql/bin/my_print_defaults --defaults-file=/data/mysql/mysql3306/my.cnf  "$1" | sed -n "s/^--$2=//p" | tail -n 1
if [ -z "$result" ]; then

not found, use default

     result="$3"
   fi

}
servername=hostname
get_mysql_option mysqld datadir "/data/mysql/mysql3306/data/"
datadir="$result"
get_mysql_option mysqld socket "/data/mysql/mysql3306/data/mysql.sock"
socketfile="$result"
get_mysql_option mysqld log-error "/data/mysql/mysql3306/data/error.log"
errlogfile="$result"
get_mysql_option mysqld pid-file "/data/mysql/mysql3306/data/mysql.pid"
mypidfile="$result"
start(){
touch "$errlogfile"
chown mysql:mysql "$errlogfile"
chmod 0640 "$errlogfile"
[ -x /sbin/restorecon ] && /sbin/restorecon "$errlogfile"

Pass all the options determined above, to ensure consistent behavior.

   # In many cases mysqld_safe would arrive at the same conclusions anyway
   # but we need to be sure.
   /usr/local/mysql/bin/mysqld_safe  --defaults-file=/data/mysql/mysql3306/my.cnf \
       --user=mysql  \
       >/dev/null 2>&1 &
   ret=$?
   # Spin for a maximum of N seconds waiting for the server to come up.
   # Rather than assuming we know a valid username, accept an "access
   # denied" response as meaning the server is functioning.
   if [ $ret -eq 0 ]; then
     STARTTIMEOUT=30
     while [ $STARTTIMEOUT -gt 0 ]; do
       RESPONSE=`/usr/local/mysql/bin/mysqladmin  -uroot -proot -P3306 -h227.0.0.1 ping 2>&1` && break
       echo "$RESPONSE" | grep -q "Access denied for user" && break
       sleep 1
       let STARTTIMEOUT=${STARTTIMEOUT}-1
     done
     if [ $STARTTIMEOUT -eq 0 ]; then
         echo "Timeout error occurred trying to start MySQL Daemon."
         action $"Starting $prog: " /bin/false
         ret=1
     else
         action $"Starting $prog: " /bin/true
     fi
   else
     action $"Starting $prog: " /bin/false
   fi
   [ $ret -eq 0 ] && touch /var/lock/subsys/mysqld
   return $ret

}
stop(){
MYSQLPID=cat "$mypidfile"  2>/dev/null
if [ -n "$MYSQLPID" ]; then
/bin/kill "$MYSQLPID" >/dev/null 2>&1
ret=$?
if [ $ret -eq 0 ]; then
STOPTIMEOUT=60
while [ $STOPTIMEOUT -gt 0 ]; do
/bin/kill -0 "$MYSQLPID" >/dev/null 2>&1 || break
sleep 1
let STOPTIMEOUT=${STOPTIMEOUT}-1
done
if [ $STOPTIMEOUT -eq 0 ]; then
echo "Timeout error occurred trying to stop MySQL Daemon."
ret=1
action $"Stopping $prog: " /bin/false
else
rm -f /var/lock/subsys/mysqld
rm -f "$socketfile"
action $"Stopping $prog: " /bin/true
fi
else
action $"Stopping $prog: " /bin/false
fi
else
ret=1
action $"Stopping $prog: " /bin/false
fi
return $ret
}

restart(){
stop
start
}
condrestart(){
[ -e /var/lock/subsys/mysqld ] && restart || :
}

See how we were called.

case "$1" in
start)
start
;;
stop)
stop
;;
status)
status mysqld
;;
restart)
restart
;;
condrestart)
condrestart
;;
*)
echo $"Usage: $0 {start|stop|status|condrestart|restart}"
exit 1
esac
exit $?

看完MySQL起停腳本操作方法這篇文章后，很多讀者朋友肯定會(huì)想要了解更多的相關(guān)內(nèi)容，如需獲取更多的行業(yè)信息，可以關(guān)注我們的行業(yè)資訊欄目。

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。

分享標(biāo)題：MySQL起停腳本操作方法-創(chuàng)新互聯(lián)
本文鏈接：http://chinadenli.net/article20/dgjgjo.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供用戶體驗(yàn)、商城網(wǎng)站、定制開發(fā)、定制網(wǎng)站、網(wǎng)站收錄、微信公眾號(hào)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)