Customize a MySQL shutdown script based on the working environment
---1. Save As/usr/local/mysql/scripts/mysql_env.ini
#set MySQL init variables
Mysql_user=system #mysql的用户名
mysql_pass= ' Password ' #mysql的登录用户密码
#check input parameter or no
If [$#-ne 1]; Then #判断输入的参数个数
echo "MySQL port is 3306"
mysql_port=3306
Else
Mysql_port=$1 #$1 is the 1th positional parameter passed in
echo "MySQL Port is $"
Fi
---2. Turn off MySQL
#!/bin/sh
#[email protected]
Source/usr/local/mysql/scripts/mysql_env.ini
MY_CNF=/USR/LOCAL/MYSQL/MY.CNF #mysql的配置文件
Mysqld_admin=/usr/local/mysql/bin/mysqladmin
Mysql_socket=/usr/local/mysql/mysql.sock
Mysql_cmd= "${mysqld_admin}-u${mysql_user}-p${mysql_pass}-S ${mysql_socket}"
Errorlog= ' Grep-i "^log-error" $MY _cnf |cut-d =-F 2 '
Init_num=1
portnum= ' Netstat-lnt|grep ${mysql_port}|wc-l '
if [!-x $MYSQLD _admin]; Then
echo "MySQL Installation when startup file is not installed to $mysqld_admin or no execute permission"
Exit 0
elif [$PORTNUM = 0]; then
echo "MySQL is off, no need to close!"
Exit 0
Else
echo "Turn off MySQL service"
${mysql_cmd} shutdown
While [$INIT _num-le 5]
Do
portnum= ' Netstat-lnt|grep ${mysql_port}|wc-l '
echo "MySQL off in .... Please wait a moment ... "
Sleep 5
if [$PORTNUM = 0];
Then
echo "MySQL * * * * * * success"
Exit 0
Fi
init_num=$ (($INIT _num + 1))
Done
Echo-e "MySQL shutdown failed, please check the error log ' echo ' Cat ' ${errorlog} '"
echo "*****************************************"
Exit 0
Fi
---3. Add environment variables
echo "Export path=/usr/local/mysql/scripts:\ $PATH" >>~/.bash_profile
SOURCE ~/.bash_profile