出現 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功能的方法!!