MySQL TYPE=MyISAM on MySQL 5.5+

A place to discuss and receive support for the Library DB application.

MySQL TYPE=MyISAM on MySQL 5.5+

Postby jonbfl » Tue Aug 02, 2011 3:47 pm

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)
jonbfl
 
Posts: 66
Joined: Thu Jul 28, 2011 8:20 pm

Return to Library DB Discussion

Who is online

Users browsing this forum: No registered users and 15 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved