-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Ian Smith wrote:
Ok, can you confirm whether you have dumped this database from another MySQL instance (for instance with mysqldump or phpmyadmin) and loaded
it
into the current one?
Aha!!! Yes, that is indeed what I did. I was upgrading Apache, PHP and MySQL, so I cloned the old Wiki to the new setup on the same machine, then ran the MediaWiki upgrade.
Ah good, one mystery solved. :)
Sorry about your data... :(
To prevent the corruption, use the --default-charset=latin1 option
while
dumping the original database with mysqldump. This prevents it from corrupting your data by applying false encoding conversions to the raw data.
Sounds like excellent advice for people following in my footsteps... too late for me, but thanks for getting to the bottom of this, anyhow.
Maybe a note about this should be added to the wiki-moving instructions:
Added.
- -- brion vibber (brion @ wikimedia.org)