检查MYISAM表是否损坏，并自动修复的脚本

[bzuo@devdb1 ~]$ cat check_table.sh
#check table when flush complete,if table crushed then repair it
#first parameter is DB name.
#!/bin/sh
if [ -z $1 ];then #if the length of DB name is zero
   echo 'Please input DB name'
   exit 0
fi

if [ -f /home/bzuo/log.log ];then #just save one time result
   rm -rf /home/bzuo/log.log
fi

for table in `mysql -uroot -p123 -e "use $1;show tables" | awk '{if(NR>1) print $0}'` #get all tables
do
done