Re: How to convert a PHPmyAdmin export sql file to older version

[Jeremy Grieff]

Like this?:

CREATE TABLE `phpbb_search_wordlist` (
`word_text` varchar(50) character NOT NULL default '',
`word_id` mediumint(8) unsigned NOT NULL auto_increment,
`word_common` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`word_text`),
KEY `word_id` (`word_id`)
) ENGINE=MyISAM AUTO_INCREMENT=28532 ;

Like this?


Like this?:

CREATE TABLE `phpbb_search_wordlist` (
`word_text` varchar(50) character NOT NULL default '',
`word_id` mediumint(8) unsigned NOT NULL auto_increment,
`word_common` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`word_text`),
KEY `word_id` (`word_id`)
) TYPE=MyISAM AUTO_INCREMENT=28532 ;


If this is the case then do I change ENGINE to TYPE in every scenario of then AUTO_INC follows it? Or do I need to change every instance of when ENGINE=MyISAM ?