Linux常用shell脚本
1. 设置ssh、scp命令的认证运行一次脚本后，以后再使用ssh或scp命令登录远程机器时不再提示输入密码
-----------------setkey.sh开始-------------------------
OLDDIR=`pwd`
if [ -z "$1" ]; then
echo Need user@host info;
exit;
fi;
cd $HOME;
if [ -e "./.ssh/id_rsa.pub" ]; then
cat ./.ssh/id_rsa.pub | ssh $1 'mkdir -p .ssh;cat >> .ssh/authorized_keys';
else
ssh-keygen -t rsa;
cat ./.ssh/id_rsa.pub | ssh $1 'mkdir -p .ssh;cat >> .ssh/authorized_keys';
fi;
cd $OLDDIR
-----------------setkey.sh结束-------------------------
用法：setkey.sh [用户名]@[要登录的目标机IP地址]
2. 进程监控程序
定时检查进程，发现进程挂掉时重启进程
-----------------loopcheck.sh开始-------------------------
#!/bin/sh
predir=`pwd`
filedir=`dirname $0`
cd "${filedir}"
curdir=`pwd`
logfilename=./loopcheck.log
#-----------------------------------
# 函数: CheckProcess
# 功能: 检查一个进程是否存在
# 参数: $1 --- 要检查的进程名称
# 返回: 如果存在返回0, 否则返回1.
#---------------------------------------
checkprocess()
{
if [ "$1" = "" ]; then
return 1
fi
# $PROCESS_NUM获取指定进程名的数目，为1返回0，表示正常，不为1返回1，表示有错误，需要重新启动
process_num=`ps -ef |grep "$1" |grep -v "grep" |wc -l`
if [ $process_num -eq 1 ]; then
return 0
else
return 1
fi
}
# 启动C++进程
startBinProcessByName()
{
/bin/$1> "log.${1}.txt" &
echo "`date` restart $1 ok" >> ${logfilename}
}
# 主逻辑
while [ 1 ]; do
# 对C++进程进行检查
tblBins=("gamesvr.bin" "dbsvr.bin")
for tblBin in "${tblBins[@]}";do
checkprocess "${tblBin} server${serverNo}"
check_result=$?
if [ $check_result -eq 1 ]; then
echo "`date` error ${tblBin}" >> ${logfilename}
startBinProcessByName "${tblBin}"
fi
done
# 每隔10秒执行一次
sleep 60
echo "`date` check ok" >> ${logfilename}
done
cd ${predir}
-----------------loopcheck.sh结束-------------------------
3. mysql数据库表自动修复脚本
-----------------checkdbtable.sh开始-------------------------
#!/bin/sh
mysql_host=localhost
mysql_user=star
mysql_pass=star
database=starcraft27
tables=$(mysql -h$mysql_host -u$mysql_user -p$mysql_pass $database -A -Bse "show tables")
for arg in $tables; do
check_status=$(mysql -h$mysql_host -u$mysql_user -p$mysql_pass $database -A -Bse "check table $arg"| awk '{ print $4 }')
if [ "$check_status" = "OK" ]
then
echo "$arg is ok"
else
echo $(mysql -h$mysql_host -u$mysql_user -p$mysql_pass $database -A -Bse "repair table $arg")
fi
# echo $(mysql -h$mysql_host -u$mysql_user -p$mysql_pass $database -A -Bse "optimize table $arg")
done
-----------------checkdbtable.sh结束-------------------------
4. mysql数据库备份脚本
-----------------backupdb.sh开始-------------------------
#!/bin/bash
predir=`pwd`
dir=`dirname $0`
cd "${dir}"
DB_DATABASE=databasename
DB_USR=username
DB_PWD=userpassword
BACKDIR=../backup/db
LOG_PATH=../backup/log
DATE=`date +%Y.%m.%d.%H.%M.%S`
targetFile=$BACKDIR/db.$DATE.tar.gz
if [ $# = 1 ];then
targetFile=$1
fi
mkdir -p $LOG_PATH
echo "backupdb begin">>${LOG_PATH}/dailyMaintenace.log
mkdir -p $BACKDIR
mysqldump -u"${DB_USR}" -p"${DB_PWD}" $DB_DATABASE >$DB_DATABASE.$DATE.sql
tar -zcf $targetFile $DB_DATABASE.$DATE.sql
rm -rf $DB_DATABASE.$DATE.sql
echo "backupdb done">>${LOG_PATH}/dailyMaintenace.log
cd "${predir}"
-----------------backupdb.sh结束-------------------------
5. mysql数据库备份恢复脚本
-----------------recoverdb.sh开始-------------------------
#!/bin/bash
predir=`pwd`
dir=`dirname $0`
cd "${dir}"
if [ $# = 0 ];then
echo please specified the source sql file for recover
exit 0
fi
if [ ! -e $1 ];then
echo "there isn't the file $1"
exit 0
fi
DB_DATABASE=databasename
DB_USR=username
DB_PWD=userpassword
RECOVERDIRTEMP=../backup/db/recovertmp
echo recovering...
mkdir -p $RECOVERDIRTEMP
rm -rf $RECOVERDIRTEMP/*
tar -xzf $1 -C $RECOVERDIRTEMP/
if [ $# = 2 ];then
mysql-u"${DB_USR}" -p"${DB_PWD}"-e "drop databaseif exists ${DB_DATABASE};create database ${DB_DATABASE};"
fi
mysql -u"${DB_USR}" -p"${DB_PWD}" $DB_DATABASE < $RECOVERDIRTEMP/*.sql
rm -f $RECOVERDIRTEMP/*.sql
echo done
cd "${predir}"
-----------------recoverdb.sh结束-------------------------
6. mysql数据库结果分析输出csv文件脚本
-----------------export_userinfo.sh开始-------------------------
#!/bin/bash
rm -rf export_out.csv
var=0
records=()
map=""
date
while read line
do
key=`echo $line | awk -F ' ' '{print $1}'`
#echo $key
result=(`mysql rxsg2_$1 --skip-column-names -e"select p.passport, u.name, u.level, o.total_online, u.vip from mem_passport p left join (mem_user u left join mem_user_online o on o.uid=u.uid) on u.uid=p.uid where p.passport='$key'"`)
len=${#result[@]}
if [ $len -ne 5 ]; then
records[$var]="$key"
else
records[$var]="${result},${result},${result},${result},${result}"
fi
#echo ${records[$var]};
var=`expr $var + 1`
#if [ $var -eq 5 ]; then
#break;
#fi
done < export_in.txt
outstr="";
echo "over";
#echo ${records
[*]} > export_result.txt
for ((i=0;i> export_out.csv
#outstr=$outstr`echo ${map[$i]}``echo "\n"`
done
#echo $outstr > export_result.txt
date
-----------------export_userinfo.sh结束-------------------------
【参考】
http://www.cnblogs.com/end/archive/2011/07/20/2111888.html
页:
[1]