mysql5,引擎从myisam 升级成innodb, 批量脚本
2019-12-06 本文已影响0人
随便写点什么就好
网上的脚本搞得太复杂,自己写一个能用的.
!/bin/bash
author by lifh; in 20191206
DBLIST="test adwords_api_test" #转换的数据库,多个用空格隔开
USER="root" # 服务器信息
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 "现在转换表 MYSQL_BIN/mysql -h
USER -p
DB -e "alter table
{ENGINE_NAME}'"
if [ {table_name} 转换成功"
else
echo "${table_name} 转换失败"
fi
done
done
