mysql引擎转化脚本示例(2)
1、较(1)简单一点的数据引擎转化脚本,仅仅实现了引擎的转换
#!/bin/bash for i in {log_data_01,log_data_02,log_data_03,log_data_04,log_data_05,log_data_06,log_data_07,log_data_08,log_data_09,log_data_10,log_data_11,log_data_12,log_data_13,log_data_14,log_data_15,log_data_16,log_data_17,log_data_18,log_data_19,log_data_20,log_data_21,log_data_22,log_data_23,log_data_24,log_data_25,log_data_26,log_data_27,log_data_28,log_data_29,log_data_30,log_data_31,log_data_32,log_data_33,log_data_34,log_data_35,log_data_36,log_data_37,log_data_38} do all_table="$(/home/mysqlapp1/product/bin/mysql -uroot -p -P3307 -S /home/mysqlapp1/dbdata/mysql.sock -e "select TABLE_NAME from INFORMATION_SCHEMA.TABLES where table_schema='$i' and table_name like '%201611%'")" for x in $all_table do echo "start alter table $i.$x `date +%F_%T`" >> /tmp/alter_table_`date +%F`.log /home/mysqlapp1/product/bin/mysql -uroot -p -P3307 -S /home/mysqlapp1/dbdata/mysql.sock -e "alter table $i.$x engine=myisam" if [ $? == 0 ];then echo "alter table $i.$x is ok `date +%F_%T`" >> /tmp/alter_table_`date +%F`.log fi done don