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