2 messages in com.mysql.lists.eventum-develCREATE TABLE statements in SCHEMA.SQL...
FromSent OnAttachments
Kevin Roberts09 Jul 2005 20:25 
Joao Prado Maia11 Jul 2005 07:11 
Subject:CREATE TABLE statements in SCHEMA.SQL should specify Engine=MyISAM
From:Kevin Roberts (kevi@hotmail.com)
Date:07/09/2005 08:25:45 PM
List:com.mysql.lists.eventum-devel

The CREATE TABLE statements in SCHEMA.SQL do not specify the engine type to use, but it seems that MyISAM is assumed. If MyISAM is assumed (or required, as in the case of tables with FULLTEXT indexes), then the DDL should include the ENGINE=MyISAM parameter.

This was a source of frustration for me since my instance of MySQL was set up to default to InnoDB when CREATE TABLE statements did not specify an engine. All attempts to create the Eventum database failed.

I changed default storage engine by using MySQL Administrator (Startup Variables > Default Storage > MyISAM) and restarting MySQL. The installation script then created the database tables without incident. However, shouldn't the CREATE TABLE statements be explicit?