Bug #16781 InnoDB related error at installation

• Submitted: 25 Jan 2006 14:48
• Modified: 6 Apr 2006 20:44
• Reporter: [ name withheld ] (Basic Quality Contributor)
• Status: Can't repeat
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.1.5/5.1.6 BK
• OS: Windows (WinXP sp2/Linux)
• CPU Architecture: Any

[25 Jan 2006 14:48] [ name withheld ]

Description:
I'm trying to install MySQL 5.1.5 max nt on WinXP sp2, in my my.ini file I have this rows:

...
# The default storage engine that will be used when create new tables when
default-storage-engine=InnoDB

when I try to get mysqld to display it's help from command line it says:

C:\Programmi\MySQL\MySQL Server 5.0\bin>mysqld-max-nt --help
Unknown/unsupported table type: InnoDB

commenting it out leads to the expected:

C:\Programmi\MySQL\MySQL Server 5.0\bin>mysqld-max-nt --help
mysqld-max-nt  Ver 5.1.5-alpha-nt-max for Win32 on ia32 (MySQL Community Edition
 (GPL) - Max)
Copyright (C) 2000 MySQL AB, by Monty and others
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Starts the MySQL database server

Usage: mysqld-max-nt [OPTIONS]

For more help options (several pages), use mysqld --verbose --help

After this it installs correctly and seems to have innodb support enabled

How to repeat:
See above

[26 Jan 2006 14:41] MySQL Verification Team

Thank you for the bug report.

c:\mysql\bin>mysqld-max-nt --standalone --console --default-storage-engine=innodb
Unknown/unsupported table type: innodb

c:\mysql\bin>mysqld-max-nt --standalone --console --default-storage-engine=innobase
060126 12:35:01  InnoDB: Started; log sequence number 0 43655
060126 12:35:02 [Note] mysqld-max-nt: ready for connections.
Version: '5.1.5-alpha-nt-max'  socket: ''  port: 3306  MySQL Community Edition (GPL) - Max

miguel@hegel:~/dbs/5.1> libexec/mysqld --default-storage-engine=innodb
Unknown/unsupported table type: innodb
miguel@hegel:~/dbs/5.1> libexec/mysqld --default-storage-engine=innobase
030426 12:40:21  InnoDB: Started; log sequence number 0 53287
030426 12:40:21 [Note] libexec/mysqld: ready for connections.
Version: '5.1.6-alpha-debug'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

[27 Feb 2006 15:56] Magnus Blåudd

Can't reproduce. Please retest with latest 5.1

[6 Apr 2006 20:44] MySQL Verification Team

I was unable to repeat with current source server.