出现 The'InnoDB'featureisdisabled;youneedMySQLbuiltwith'InnoDB' 的解决方案
-- ----------------------------
-- Table structure for `msg`
-- ----------------------------
DROP TABLE IF EXISTS `msg`;
CREATE TABLE `msg` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`fromid` bigint(20) DEFAULT NULL,
`toid` bigint(20) DEFAULT NULL,
`insert_time` datetime DEFAULT '0000-00-00 00:00:00',
`comment_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8;
MySQL出现如下语句:The ‘InnoDB’ feature is disabled; you need MySQL built with ‘InnoDB’ to have it working;
是mysql配置文件禁掉了这个选项!
关闭mysql数据库
在mysql的安装目录中找到my.ini文件
找到skip-innodb,在前面加上#号
保存,开启mysql数据库!搞定!
这也是开启Mysql数据库InnoDB功能的方法!!