[Mediawiki-l] mysql5 binary schema

[Platonides]

Ben Willmore wrote:
> I need to use mysqldump to back up the wiki. So -- how can I upgrade
> my mysql4 database to one of the new mysql 5 schemata?
> 
> Thanks,
> 
> Ben

You can use mysqldump with mysql 4 schema. You just need to avoid mysqld
dump 'helpfully' converting the charset. Call it with the option
--default-character-set=latin1 (the data is in fact UTF-8 but we make
msyql think it's latin1, it's the charset conversions what break it)

http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki#Character_set