Bug #23386 Administrator can deactivate default storage engine without notice

• Submitted: 17 Oct 2006 18:26
• Modified: 18 Oct 2006 0:18
• Reporter: [ name withheld ]
• Status: Can't repeat
• Category: MySQL Administrator
• Severity: S2 (Serious)
• Version: 1.24 rc
• OS: Windows (Windows XP SP2)
• CPU Architecture: Any
• Tags: administrator, default storage engine

[17 Oct 2006 18:26] [ name withheld ]

Description:
If InnoDB is default storage engine, it can be deactivated without notice. Next time you try to start the Server, it fails.

Workaround: Reconfigure the Server using the instance config wizard.

How to repeat:
Set InnoDB as default storage engine. Then, in the administrator, go to start variables, then to the tab InnoDB parameters. There, disable "Activate InnoDB".
Then shutdown and restart MySQL Server.

Suggested fix:
The administrator should at least ask, if he's allowed to deactivate the default storage engine, or completely disallow deactivation.

[18 Oct 2006 0:18] MySQL Verification Team

Thank you for the bug report. I was unable to repeat what you are reporting,
notice that unckeck Activate InnoDB should means to add to the my.ini file
the key skip-innodb and currently there is another bug report that those
changes are done outside of the [mysqld] server section:

# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this 
# file.
#
#Enable this option only if you would like to use InnoDB tables.
skip-innodb

[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306

so what are you reporting should not happens, also notice when it will
be fixed only takes effect when you press Apply Changes.