Mysql Prompts the InnoDB feature is disabled to open a InnoDB solution _mysql

The example of this article analyzes the MySQL hint the InnoDB feature is disabled need to open the InnoDB solution. Share to everyone for your reference, specific as follows:

First, the question:

Create a data table error:

ERROR 1289:the ' InnoDB ' feature is disabled; You are need MySQL built with ' InnoDB ' to have it working

Open DoD command line, login (about MySQL using the DOS command line login method to view the previous "MySQL based on DOS command line login operation example (graphic description)") and view the next

Copy Code code as follows:

Show variables like "have_%";

Found InnoDB cannot be used. Just not active

Second, the solution:

view My.ini file, found that skip-innodb this property is turned on, as long as the mask off on it, in front of the # number . ( Note : you need to precede the skip-innodb with the # number, not the #)

Finally restart the MySQL service is OK.

I hope this article describes the design of MySQL database to help.