Shell脚本操作MySQL服务

1、编写Shell脚本

#! /bin/shcase $1 in    start)        /usr/local/mysql/bin/mysqld_safe --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql &        echo "MySQL service has stated."        ;;    stop)        killall mysqld;        echo "MySQL service has stoped."        ;;    restart)        killall mysqld        /usr/local/mysql/bin/mysqld_safe --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql &        echo "MySQL service has restarted."        ;;    *)        echo "No such argument."        exit 1        ;;esac

2、创建软链接，将脚本作为服务运行

shell> sudo ln -s ~/workspace/shell/mysql/mysqld /etc/init.d/mysqld

3、启动、停止、重启MySQL服务

shell> sudo service mysqld startshell> sudo service mysqld stopshell> sudo service mysqld restart