shell脚本编写MySQL建议简易启动脚本,练习使用变量,函数,case语句等知识;
[root@localhost baby]# cat mysql_function.sh
#!/bin/bash
. /etc/init.d/functions
path=/usr/local/mysql/bin/
function usage(){
?echo "$0 {start|stop|restart}"
?exit 1
}
[ $# -ne 1 ] && usage
?
function_mysql_start(){
? ? $path/mysqld_safe --user=mysql &>/dev/null &
?if [ $? -eq 0 ]
? then
? ? ? sleep 5
? ? ? action "start mysql" /bin/true
?else
? ? ? action "start mysql" /bin/false
?fi
}
?
function_mysql_stop(){
? ? $path/mysqladmin -uroot shutdown &>/dev/null
? ? if [ $? -eq 0 ]
? ? ? then
? ? ? ? ? action "stop mysql" /bin/true
? ? else
? ? ? action "stop mysql" /bin/false
? ? fi
}
?
function_mysql_restart(){
? ? function_mysql_stop
? ? sleep 3
? ? function_mysql_start
}
?
case $1 in
?start)
?function_mysql_start
?;;
?stop)
?function_mysql_stop
?;;
?restart)
?function_mysql_restart
?;;
?*)
?printf "Usage:$0 {start|stop|restart}\n"
esac
执行结果如下图所示:
