MySQL Error: ENGINE = MyISAM invalid SQL?

[Wayne Luke]

In newer versions of MySQL the export of a table would be:

CREATE TABLE `vb_access` (
  `userid` int(10) unsigned NOT NULL default '0',
  `forumid` smallint(5) unsigned NOT NULL default '0',
  `accessmask` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`,`forumid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

For MySQL 4.0 compatibility it would be:

CREATE TABLE `vb_access` (
  `userid` int(10) unsigned NOT NULL default '0',
  `forumid` smallint(5) unsigned NOT NULL default '0',
  `accessmask` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`,`forumid`)
) TYPE=InnoDB;

Just export the table with the --compat MYSQL40 flag as show here:
http://www.vbulletin.com/docs/html/m...servers_backup

Or just remove everything after the closing parenthesis for each table declaration. If it isn't specified than MySQL will use its defaults.