检查数据库是否是innodb引擎

1040阅读 0评论2013-05-04 zhengsenlin888
分类:LINUX


  1. mysql -uroot -p123456 -e "use information_schema;select concat('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' ENGINE = InnoDB;') from TABLES where TABLE_SCHEMA like 'xxxdb_%' and ENGINE != 'InnoDB';"

上一篇:awk
下一篇:检查tcp/udp 连接情况