出現(xiàn) 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出現(xiàn)如下語句:The ‘InnoDB’ feature is disabled; you need MySQL built with ‘InnoDB’ to have it working;
是mysql配置文件禁掉了這個選項(xiàng)!
關(guān)閉mysql數(shù)據(jù)庫
在mysql的安裝目錄中找到my.ini文件
找到skip-innodb,在前面加上#號
保存,開啟mysql數(shù)據(jù)庫!搞定!
這也是開啟Mysql數(shù)據(jù)庫InnoDB功能的方法!!