mysql一括削除データベース下表
#!/bin/bash
dbip='192.7.3.5'
dbuser='root'
dbpwds='123456'
dbname='logging'
cat /home/tablenames.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
ここでtablenames.txtは以下の通りである.
actionlog_20171130
actionlog_20171201
actionlog_20171202
actionlog_20171203
actionlog_20171204
actionlog_20171205
actionlog_20171206
...