Bug #32470 mysql_install_db can't handle InnoDB as storage engine specified in a my.cnf
Submitted: 17 Nov 2007 15:38 Modified: 19 Nov 2007 8:18
Reporter: Roland Bouman Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:5.1.22 OS:Any
Assigned to: CPU Architecture:Any

[17 Nov 2007 15:38] Roland Bouman
Description:
Running mysql_install_db using an option file that contains:

default_storage_engine = InnoDB

will fail to install the system tables. The error is

071001 19:55:33 [ERROR] Unknown/unsupported table type: innodb
071001 19:55:33 [ERROR] Aborting

see: http://fschiettecatte.wordpress.com/2007/10/02/mysql-5122/

How to repeat:
see: http://fschiettecatte.wordpress.com/2007/10/02/mysql-5122/

Suggested fix:
Please use explicit ENGINE clauses for the CREATE TABLE statements in case the engine matters
[19 Nov 2007 8:18] Sveta Smirnova
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.
[19 Nov 2007 8:19] Sveta Smirnova
Duplicate of bug #31315