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

[Jeremy Grieff]

This is what the DEFAULT CHARSET looks like in my sql file...found a bunch of times, but in different context every time.

(`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

(`forum_last_post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

and so on...

For the COLLATE:

phpbb_search_wordlist`
--

CREATE TABLE `phpbb_search_wordlist` (
`word_text` varchar(50) character set latin1 collate latin1_bin NOT NULL default ''


So what do I take out?