Shulou(Shulou.com)06/01 Report--

vi convert_tbale_engine.sh

#!/ bin/bash

DB=test

USER=root

PASSWORD=123456

HOST=192.168.1.10

MYSQL_BIN=/usr/local/bin

S_ENGINE=MyISAM

D_ENGINE=InnoDB

$MYSQL_BIN/mysql -h$HOST -u$USER -p$PASSWORD $DB -s -e "select table_name from infomation_schem.table where table_schema='test' and engine='myisam'"|grep -v "table_name" >table.txt

for t_name in `cat table.txt`

do

echo "Staring convert table $t_name... "

sleep 1

$MYSQL_BIN/mysql -h$HOST -u$USER -p$PASSWORD $DB -e "alter table $t_name engine=$D_ENGINE"

if [ $? -eq 0 ];then

echo "Convert table $t_name ended ">con_table.log

sleep 1

else

echo "Convert tbale $t_name failed ">con_table.log

fi

done

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.