[文章作者:张宴 本文版本:v1.0 最后修改:2008.07.24 转载请注明原文链接:http://blog.zyan.cc/post/359/]

  写了一个shell脚本,可以在同一台Linux服务器的不同端口,运行多个MySQL服务的情况下,快捷启动、停止、重启、杀死指定端口的MySQL进程。

vi /usr/local/bin/mysql.sh

  输入以下内容(因各服务器的MySQL配置不同,可能需要修改的部分已用红色标注):
#!/bin/sh

mysql_port=$2
mysql_username="root"
mysql_password="123456"

function_start_mysql()
{
    printf "Starting MySQL...\n"
    /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/mysql/${mysql_port}/my.cnf 2>&1 > /dev/null &
}

function_stop_mysql()
{
    printf "Stoping MySQL...\n"
    /usr/local/mysql/bin/mysqladmin -u ${mysql_username} -p${mysql_password} -h localhost -P ${mysql_port} shutdown
}

function_restart_mysql()
{
    printf "Restarting MySQL...\n"
    function_stop_mysql
    function_start_mysql
}

function_kill_mysql()
{
    kill -9 $(ps -ef | grep 'bin/mysqld_safe' | grep ${mysql_port} | awk '{printf $2}')
    kill -9 $(ps -ef | grep 'libexec/mysqld' | grep ${mysql_port} | awk '{printf $2}')
}

if [ "$1" = "start" ]; then
    function_start_mysql
elif [ "$1" = "stop" ]; then
    function_stop_mysql
elif [ "$1" = "restart" ]; then
    function_restart_mysql
elif [ "$1" = "kill" ]; then
    function_kill_mysql
else
    printf "Usage: mysql.sh {start|stop|restart|kill}\n"
fi


  赋予脚本可执行权限:
chmod +x /usr/local/bin/mysql.sh


  脚本执行方法:
mysql.sh start 3306
mysql.sh stop 3306
mysql.sh restart 3306
mysql.sh kill 3306



Tags: , , , ,
技术大类 » 数据库技术 | 评论(110) | 引用(0) | 阅读(54680)
GAWER
2013-3-5 13:49
买轴承就到:www.jkzhoucheng.cn
Niemts Homepage
2013-3-13 15:26
The uppers bunk Cheap Nike Shox Shoes FUSE technology with serrated shoe covers designed to completely fit the foot, and to help Nike Shox NZ Shoes
you moments best surf trip. The mold collar prevents heel shoes slide and still maintain high Nike Shox R4 Womens stability, even in high-speed running state. Foam midsole is lightweight and flexible, and can be used with air to provide a full range of cushioning protection. Nike Shox NZ Mens The running shoes applied new technology to build for elite athletes, and dynamic support system perfect fusion running shoes highly disruptive innovation and upgrading.[B][/B]
Parloi Email Homepage
2013-3-14 16:58
The uppers bunk Cheap Nike Shox Shoes BLEND technology by using serrated casino shoe tops designed to completely healthy that foot, and to aid you moments Nike Shox NZ Shoes greatest waves trip. That mildew collar prevents back heel shoes and boots slide and nonetheless manage Nike Shox R4 Womens higher stability, even within high-speed running state. Foam midsole is actually lightweight in addition to accommodating, Nike Shox NZ Mens and may end up being combined with atmosphere to deliver a full range connected with padding protection. That operating shoes and boots used fresh technologies to build with regard to snobs athletes, in addition to strong service system excellent blend operating shoes remarkably disruptive advancement and improving.
磨延城 Email Homepage
2013-10-21 21:12
磨途歌学习了
分页: 6/6 第一页 上页 1 2 3 4 5 6 最后页
发表评论
表情
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
emotemotemotemotemot
打开HTML
打开UBB
打开表情
隐藏
记住我
昵称   密码   游客无需密码
网址   电邮   [注册]