重置mysql数据_重置mysql数据库shell脚本

#!/bin/bash

user=

pwd=

function help_info(){

echo "Tool to reset mysql server"

echo "Usage:"

echo "$0 "

}

if [ $# -eq 2 ];then

user=$1

pwd=$2

elif [ $# -ne 2 ];then

help_info

exit 1

fi

src=/usr/local/mysql/data

cd $src

mv mysql mysql_bak && mv performance_schema performance_schema_bak && mv test test_bak >/dev/null 2>&1

rm -rf `ls | grep [^_bak]$`

mv mysql_bak mysql;mv performance_schema_bak performance_schema; mv test_bak test

service mysql restart

mysql_status=`service mysql status | grep "MySQL running" | awk -F " " '{print $1 $2}'`

#echo $mysql_status

if [ "$mysql_status" == "MySQLrunning" ];then

echo "MYSQL server is running"

else

echo "Begin to start mysql server..."

kill -9 `ps -ef | grep "/usr/local/mysql/bin" | grep -v grep | awk -F " " '{print $2}'`&& service mysql start

fi

function clearData()

{

echo "Begin to reset mysql server"

mysql -h 127.0.0.1 -u$user -p$pwd << EOF

use mysql;delete from user where user not in('root','mysql');

delete from user where user='mysql' and host not in ('localhost','linux','127.0.0.1','::1','%');

stop slave ;reset master;

EOF

if [ $? -eq 0 ];then

echo "Reset mysql server sucessfully..."

else

echo "Reset mysql fail..."

fi

}

clearData

分享到：

2011-06-17 19:36

浏览 1237

分类:数据库

评论