[shell]MySQL啟停指令碼

標籤：

寫了個較為完善的mysql多執行個體的啟動停止指令碼.

[[email protected] 3307]# cat mysql#!/bin/sh[ $# != 1 ]&&{    echo "USAGE:/data/3307/mysql {start|stop}"    exit 0}if [ "$1" == "start" ];then    if [ ! -f /data/3307/mysqld.pid ];then        /application/mysql/bin/mysqld_safe --defaults-file=/data/3307/my.cnf 2>&1 >/dev/null &        sleep 5        echo "Starting MySQL..."    else        echo "MySQL is running already!"    fielif [ "$1" == "stop" ];then    if [ -f /data/3307/mysqld.pid ];then        /application/mysql/bin/mysqladmin -S /data/3307/mysql.sock -uroot -p123456 shutdown 2>&1 >/dev/null &        echo "Stoping MySQL..."    else            echo "MySQL is Stopped already!"    fifi

注意點:

1.mysql放在/data/3307/目錄下,且有執行許可權

2,指令碼裡命令用全路徑,譬如

   /application/mysql/bin/mysqladmin

3,判斷一個檔案存在與否

存在:　　[ -f /data/3307/mysqld.pid ];

不存在:   [ ! -f /data/3307/mysqld.pid ];

4,字串比較幾點注意:4.1 雙引號 4.2等號兩邊空格,且==  4.3[  ]兩邊均空格

[ "$1" == "stop" ]

 

[shell]MySQL啟停指令碼