WDlinux官方论坛 - Powered by Discuz! Board

#!/bin/bash
#dx2_myisam2innodb.sh
USER="root"
PASS="ichejie.com"
FILE_SQL="sql.myisam2innodb"
NAME_DB="testichejie"
cat > "${FILE_SQL}" << EOF
USE ${NAME_DB};
ALTER TABLE pre_forum_postposition DROP PRIMARY KEY,ADD PRIMARY KEY(position,tid);
ALTER TABLE pre_common_member_grouppm DROP PRIMARY KEY,ADD PRIMARY KEY(gpmid,uid);
ALTER TABLE pre_forum_post DROP PRIMARY KEY,ADD PRIMARY KEY(position,tid);
EOF
mysql -u"${USER}" -p"${PASS}" -ANe "SELECT CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') as ToSQL from information_schema.tables where TABLE_SCHEMA='${NAME_DB}' and ENGINE='MYISAM' order by TABLE_ROWS;" >> "${FILE_SQL}"
mysql -u"${USER}" -p"${PASS}" < "${FILE_SQL}"

复制代码