Bug #55030 [ERROR] unknown option '--skip-innodb' after checking skip-innodb
Submitted: 6 Jul 2010 15:39 Modified: 17 Sep 2010 10:19
Reporter: Tommy Tremblay Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.24 OS:Windows (2008R2 with MySQL 5.1.48)
Assigned to: Maksym Yehorov CPU Architecture:Any
Tags: error, MySQL, skip-innodb, unknow option, workbench

[6 Jul 2010 15:39] Tommy Tremblay
After checking "skip-innodb" in Workbench and restarting MySQL server, Innodb will still be active.

How to repeat:
Open Workbench, then go to ---> Server Administration ---> InnoDB Parameters ---> check "skip-innodb" ---> apply and restart MySQL server.  You will have this in the error log:

100706 10:38:42 [ERROR] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: unknown option '--skip-innodb'

Suggested fix:
Open my.ini and change :

skip-innodb =



save and restart MySQL server.
[6 Jul 2010 16:43] Maksym Yehorov
I can't repeat in 5.2.25.
Can you please check with latest 5.2.25 version?
[6 Jul 2010 16:58] Tommy Tremblay
Nope, I can't reproduce it with 5.2.25.  I notice that when disabling it and apply, it still says "Removed: [mysqld] skip-innodb = " instead of "Removed: [mysqld] skip-innodb".  But it works anyway.
[30 Aug 2010 12:52] Maksym Yehorov
[16 Sep 2010 23:51] Johannes Taxacher
can be closed as fixed in 5.2.26
[17 Sep 2010 10:19] Tony Bedford
An entry has been added to the 5.2.26 changelog:

In the Administrator, if the MySQL server configuration file was modified to enable skip-innodb, and the server restarted, InnoDB was still active.