shell脚本批量清理库下的大量日志历史表

#!/bin/bash 

dbip='192.168.1.1
dbuser='root
dbpwds='111111
dbname='percona'
# /home/tablename.txt 存放的是要删除的表名 一行一个表名
#另外一种方式也可以 select table_name from information_schema.tables where table_schema='dbname'动态获取库下的表然后删除
cat /home/tablename.txt | while read myline
do
 time=`date +%Y%m%d%H%M%S`
 echo "--start delete $myline--${time}--" >> /home/deltable.log
 delsql="DROP TABLE $myline"
 mysql -h${dbip} -u${dbuser} -p${dbpwds} ${dbname} -e "${delsql}"
 endtime=`date +%Y%m%d%H%M%S` 
 if [ $? -eq 0 ]; then
    echo "--delete $myline success--${endtime}" >> /home/deltable.log
 else
    echo "--delete $myline fail--${endtime}" >> /home/deltable.log
 fi
done