首页 > 技术文章 > MySQL的启动脚本

along1226 2015-11-23 16:14 原文

自己写的MySQL的启动脚本

脚本一:

#!/bin/sh

. /etc/init.d/functions
[ $# -ne 1 ] && {
echo "USAGE:{start|stop|restart}"
exit 1
}
start(){
if [ -e /data/3307/mysqld.pid ]
then
  echo "MySQL is running."
else
  /application/mysql/bin/mysqld_safe --defaults-file=/data/3307/my.cnf &>/dev/null &
  action  "MySQL is starting" /bin/true
  exit 0
fi
}

stop(){
if [ -e /data/3307/mysqld.pid ]
then
  /application/mysql/bin/mysqladmin -uroot -p123456 -S /data/3307/mysql.sock shutdown &>/dev/null
  action "MySQL is stoping" /bin/true
else
  action "MySQL is stoping" /bin/false
  exit 1
fi
}

restart(){
  stop
  sleep 2
  start
}

if [ "$1" == "start" ]
then
  start
elif [ "$1" == "stop" ]
then
  stop
elif [ "$1" == "restart" ]
then
  restart
else
  echo "USAGE:{start|stop|restart}" 
fi

脚本二:

#!/bin/sh

. /etc/init.d/functions

start(){
if [ -e /data/3307/mysqld.pid ]
then
  echo "MySQL is running."
else
  /application/mysql/bin/mysqld_safe --defaults-file=/data/3307/my.cnf &>/dev/null &
  action  "MySQL is starting" /bin/true
  exit 0
fi
}

stop(){
if [ -e /data/3307/mysqld.pid ]
then
  /application/mysql/bin/mysqladmin -uroot -p123456 -S /data/3307/mysql.sock shutdown &>/dev/null
  action "MySQL is stoping" /bin/true
else
  action "MySQL is stoping" /bin/false
  exit 1
fi
}

restart(){
  stop
  sleep 2
  start
}

case $1 in 
  start)
        start
        ;;
  stop)
        stop
        ;;
  restart)
        restart
        ;;
  *)
        echo "USAGE:$0 {start|stop|restart}"
        exit 1
esac

 

推荐阅读