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
• Status: Closed
• 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

Description:
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 =

to:

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

Fixed

[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.