#!/bin/sh
mysql_in=/mnt/data/mysql-arm
mysql_bin=${mysql_in}/bin/mysql
mysql_user=root
check_database()
{
list=`mysql -uroot -e "use dispatch_web;show tables"`
for i in $list
do
if [ "$i" = "Tables_in_dispatch_web" ]
then
echo $i
else
var=`mysql -uroot -e "use dispatch_web;select count(*) from ${i}"|grep ERROR`
echo "var=${var}"
if [ -n "$var" ]
then
mysql -uroot -e "use dispatch_web;REPAIR TABLE ${i} USE_FRM"
echo "repaired ${i}"
else
echo "${i} is normal"
fi
fi
done
}
###############################################################################
check_database
mysql_in=/mnt/data/mysql-arm
mysql_bin=${mysql_in}/bin/mysql
mysql_user=root
check_database()
{
list=`mysql -uroot -e "use dispatch_web;show tables"`
for i in $list
do
if [ "$i" = "Tables_in_dispatch_web" ]
then
echo $i
else
var=`mysql -uroot -e "use dispatch_web;select count(*) from ${i}"|grep ERROR`
echo "var=${var}"
if [ -n "$var" ]
then
mysql -uroot -e "use dispatch_web;REPAIR TABLE ${i} USE_FRM"
echo "repaired ${i}"
else
echo "${i} is normal"
fi
fi
done
}
###############################################################################
check_database