mysql error 'TYPE=MyISAM' mysql error 'TYPE=MyISAM' mysql mysql

mysql error 'TYPE=MyISAM'


Replace

TYPE=MyISAM

with

ENGINE=MyISAM

The problem was "TYPE=MyISAM" which should be "ENGINE=MyISAM" as per MySQL version updates - a simple search / replace has fix it.


Do not use the keyword TYPE anymore. Use ENGINE instead.

TYPE keyword is depreciated (since 5.0) and not supported in MySQL5.5

CREATE TABLE mantis_config_table (    ...   ) ENGINE = MyISAM;^^^^^^--------------------- HERE


In newer MySQL Versions its:

ENGINE=MyISAM

here the tutorial (MySQL)