MySQL Error: ENGINE = MyISAM invalid SQL?

[Megareus Rex]

Originally Posted by 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.

Ah, ok, I'll try that. Thanks for the help so far