網(wǎng)上的腳本搞得太復(fù)雜,自己寫(xiě)一個(gè)能用的.
!/bin/bash
author by lifh; in 20191206
DBLIST="test adwords_api_test" #轉(zhuǎn)換的數(shù)據(jù)庫(kù),多個(gè)用空格隔開(kāi)
USER="root" # 服務(wù)器信息
PASSWORD="XXXXXX"
HOST="192.168.11.121"
MYSQL_BIN="/usr/local/mysql/bin"
ENGINE_NAME="InnoDB"
for DB in {DB}"
HOST -u
PASSWORD -e "select table_name from information_schema.TABLES where TABLE_SCHEMA='
{DB}_table.txt
for table_name in cat /tmp/convert_${DB}_table.txt
do
echo "現(xiàn)在轉(zhuǎn)換表 MYSQL_BIN/mysql -h
USER -p
DB -e "alter table
{ENGINE_NAME}'"
if [ {table_name} 轉(zhuǎn)換成功"
else
echo "${table_name} 轉(zhuǎn)換失敗"
fi
done
done
