Mysql batch repair and mysql repair
#! /Bin/bashhost_name = 127.0.0.1user _ name = user_pwd = database = need_optmize_table = falsetables = $ (/usr/local/webserver/mysql/bin/mysql-h $ host_name-u $ user_name- p $ user_pwd $ database-A-Bse "show tables ") for table_name in $ tablesdo check_result = $ (/usr/local/webserver/mysql/bin/mysql-h $ host_name-u $ user_name-p $ user_pwd $ database-A-Bse" check table $ table_name "| awk '{print $4 }') if ["$ check_result" = "OK"] then echo "It's no need to repair table $ table_name" else echo $ (/usr/local/webserver/mysql/bin/ mysql-h $ host_name-u $ user_name-p $ user_pwd $ database-A-Bse "repair table $ table_name ") fi #...,..... if [$ need_optmize_table = true] then echo $ (/usr/local/webserver/mysql/bin/mysql-h $ host_name-u $ user_name-p $ user_pwd $ database-- bse "optimize table $ table_name ") fidone