#!/bin/sh
# A little script to check with 'check table' a specific mysql database
db='dbname';
log_f='check-tables.log';
pwd='password';
for i in $(echo -e "use $db;\nshow tables;\n" |
mysql -u root -p$pwd | grep -v "Tables_in_$db"); do 
echo -e "use $db;\ncheck table $i
\n" | mysql -u root -p$pwd >>./$log_f 2>&1; done