MySQL Forums
Forum List  »  Newbie

Re: The 'InnoDB' feature is disabled
Posted by: Dan Prosser
Date: November 15, 2005 11:00PM


I also had this problem and fixed it by deleting BOTH my DATA and LOG files at the same time and restarting the server.

For example,

Step 1. Stop MySQL service

Step 2. Delete files:

C:\Program Files\MySQL\MySQL Server 5.0\data\ib_logfile*
C:\MySQL Datafiles\ibdata*

Step 3: Restart MySQL service

MySQL InnoDB needs to create both DATA and LOGS at the same time -- it says this in the log file output. So if you don't delete both data and log files at the same time when it starts up it will fail to create the InnoDB database files properly and InnoDB will show up as DISABLED rather than DEFAULT (when using "show engines").


Options: ReplyQuote

Written By
November 11, 2005 05:36PM
Re: The 'InnoDB' feature is disabled
November 15, 2005 11:00PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.