The following statement appears: The ' InnoDB ' feature is disabled; You are need MySQL built with ' InnoDB ' to have it working;
is the MySQL tutorial configuration file banned this option!
To close the MySQL database tutorial
Locate the My.ini file in the MySQL installation directory
Find Skip-innodb, add the # to the front
Save, open MySQL database! Get!
This is also the way to open MySQL database InnoDB function!!
Start No workaround
090613 10:15:27 [ERROR] Default storage Engine (InnoDB) is not available
090613 10:15:27 [ERROR] Aborting
090613 10:15:27 [note] C:wwwmysqlbinmysqld-nt:shutdown complete
It is estimated that the last time the parameter has been added, has not started up. It's been a long time since MySQL was out of this machine.
Check the next, the original My.ini in a sentence: Default-storage-engine=innodb, the default engine set for INNODB, and I added Skip-innodb, no wonder the Kai is not coming.
Change Default-storage-engine to Myisam,mysql start ok!
Under the SKIP-INNODB, the data directory ibdata1,ib_logfile0,ib_logfile1 the three files are not needed, you can delete.
After testing, the three files were deleted when the Skip-innodb was not added, and the three files were automatically created when the log was started, as follows:
Reference
Innodb:the-specified data file. Ibdata1 did not exist:
INNODB:A new database to is created!
090613 10:19:37 innodb:setting file. Ibdata1 size to MB
Innodb:database physically writes the file full:wait ...
090613 10:19:37 innodb:log file. Ib_logfile0 did not exist:new to be created
innodb:setting log file. Ib_logfile0 size to MB
Innodb:database physically writes the file full:wait ...
090613 10:19:38 innodb:log file. Ib_logfile1 did not exist:new to be created
innodb:setting log file. Ib_logfile1 size to MB
Innodb:database physically writes the file full:wait ...
Innodb:doublewrite Buffer not found:creating new
Innodb:doublewrite Buffer Created
Innodb:creating FOREIGN KEY constraint system tables
Innodb:foreign key constraint system tables created
090613 10:19:39 innodb:started; Log sequence number 0 0
090613 10:19:39 [note] C:wwwmysqlbinmysqld-nt:ready for connections.
Delete these three files again, add Skip-innodb, start log:
Reference
090613 10:30:12 [note] C:wwwmysqlbinmysqld-nt:normal shutdown
090613 10:30:12 [note] C:wwwmysqlbinmysqld-nt:shutdown complete
090613 10:30:17 [note] C:wwwmysqlbinmysqld-nt:ready for connections.
Version: ' 5.0.45 ' socket: ' port:3306 Source distribution