Script to fix MySQL table

#!/bin/bash    
#author: Itnihao    
#mail: itnihao@qq.com    
#date 2013-02-18    
#version v1.0    
#function: Repair MySQL table
        
    user=root    
    password=123456    
    host=192.168.1.10    
    database=$ (Mysql-u${user}-p${ Password}-h${host}  -e ' show databases ' |grep-v  ' Database ' for    
dbname in ${database}    
       do  table=$ (Mysql-u${user}-p${password}-h${host} ${dbname}-e ' show tables ' |grep-v tables_in_mysql) for    
      TableName in ${table}    
do mysql-u${user}-p${password}-h${host} ${dbname}-e "check table ${tablename}" ["$?"!= 0] & &mysql-u${user}-p${password}-h${host} ${dbname}-e "Repair table ${tablename}" done