Apache日志备分，分析后导入数据表

#!/bin/bash
#apachebak.sh
yesterday=`date -d yesterday +%Y%m%d`
srclog="/alidata/log/httpd/cbd88.log"
dstlog="/alidata/log/httpd/cbd88_${yesterday}.log"
mv $srclog $dstlog
pkill -1 httpd


tmpfile=$$.txt


cat $dstlog|awk '{print $1}' |sort|uniq -c|awk '{print $2":"$1}' > $tmpfile
mysql='/alidata/server/mysql-5.6.21/bin/mysql -uroot -p123'
for i in `cat $tmpfile`
do
ip=`echo $i|awk -F: '{print $1}'`
num=`echo $i|awk -F: '{print $2}'`
sql="insert into home.pvcount(date,ip,num) values('$yesterday','$ip','$num')"
$mysql -e "$sql"
done
rm -rf $tmpfile