【常用命令】shell

获取当前所在目录

currentdir=$(cd "$(dirname "$0")"; pwd) 

date和+中间要有空格，获取当前时间和日期

baktime=`date "+%Y-%m-%d-%H-%M-%S"`  
clear_dir=`date +"%Y-%m-%d" -d'-1 day'` 
remove_date=`date "+%Y-%m-%d"`

获取$app项目的进程号

pid=`ps -ef|grep engine|grep -v grep|awk '{print $2}'`

查找某目录下两天前的.log文件，并删除

find $ROOT_DIR/* -type f -name *.log -mtime +2 -exec rm -rf {} \;

记录日志

echo "`date "+%Y-%m-%d %H:%M:%S" ` 当前备份: ${bak_mode}" | tee -a ${log_file}

mysql

mysqldump备份指定表

不指定表不写表名即可

/usr/local/mysql/bin/mysqldump --opt -h${DB_IP} -P${DB_PORT} -u${DB_USER} -p${DB_PWD} ${DB_NAME} ismsx_idcbasicinfo  > /appslog/basicdata/${DATE}/basicdata_${TIME}.sql

执行sql语句

/usr/local/mysql/bin/mysql -h${DB_IP} -P${DB_PORT} -u${DB_USER} -p${DB_PWD} -D${DB_NAME} -e"select count(1) from table"

执行sql文件

/usr/local/mysql/bin/mysql -h${DB_IP} -P${DB_PORT} -u${DB_USER} -p${DB_PWD} -D${DB_NAME} --force < /appslog/basicdata/${RESTORE_DATE}/basicdata${RESTORE_TIME}.sql

从文件中获取数据

DB_IP=127.0.0.1格式

DB_IP=`cat ${server_path}/conf/baseClass.conf| grep "^db_ip=" | cut -d '=' -f2 | head -1`
或
TOMCAT_PORT=`cat /usr/local/tomcat/webapps/act-idc-web/WEB-INF/classes/config.properties | grep "tomcat" | awk -F'=' '{print $2}'`