On 24/01/13 21:23, Holger wrote: > Dear list, > > I'm trying to convert a mediawiki-mysql-dump from latin1 to utf-8 to > move from MySQL 4.0.27 to MySQL 5.x. > > What I did so far was searching for a working way to achieve this. I > found several solutions which in my eyes did not work. > > Is there a recommende way, which will almost ever _works_? > > Or are not all data important to convert e.g. _objectcache? > > regards Holger
You don't need to convert the database. Although MediaWiki told to mysql that the fields were latin1, it was in fact storing utf-8 there. (If you were upgrading from a really really really old MediaWiki, you could have latin1 there, but there the maintenance scripts handle that, too) So you only need to be careful that mysql doesn't mangle characters (‘helpfully’ translating from latin1...) the when dumping / restoring the backup. _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
