Hi,
according to the purpose of our wiki we have many pages with Chinese titles, which works just fine.
But every time I backup the MySQL database (i.e. create a db dump) with phpMyAdmin and restore it all pages with Chinese titles are broken.
See: - http://wiki.rockinchina.com/index.php?title=%E7%83%82%E6%8E%89%E5%90%A7_(P.K...) - http://wiki.rockinchina.com/index.php?title=%C3%87%C6%92%E2%80%9A%C3%A6%C5%B...) (Both should be the same. The page definitely exists.)
Most tables in the db are of type InnoDB and have the collation latin1_swedish_ci.
MediaWiki 1.12.0 MySQL 5.0.32-Debian_7etch4-log phpMyAdmin 2.11.4
I am by far no db expert, nor an encoding expert. Can and should I change the collation to something else??
As I said, running the site works fine, but dumping and importing the data back into the datebase breaks Chinese page titles. How can I make good backups which do not corrupt those entries??
Beside phpMyAdmin I also do have limited shell access to the server (phphshell).
Any hints are welcome!
Thanks, Matthias