Page 1 of 1

MySQL TYPE=MyISAM on MySQL 5.5+

PostPosted: Tue Aug 02, 2011 3:47 pm
by jonbfl
In the event anyone decides to use this application effectively as a tutorial AND you are running MySQL 5.5 +:

SQL import alert: the TYPE=(enginetype) in CREATE TABLE and ALTER TABLE is obsolete as of MySQL 5.5 (when InnoDB became the default engine).

http://dev.mysql.com/doc/refman/5.5/en/ ... table.html
Note
The older TYPE option was synonymous with ENGINE. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead.


You will need to edit the install/install.sql file OR the SQL copy provided in install.php

Search for TYPE=MyISAM Replace with ENGINE=MyISAM

Good luck
8)