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