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=烂掉吧_(P.K._14)
-
http://wiki.rockinchina.com/index.php?title=ǃ‚掉å%3F§_(P.K._14)
(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
--
Rock in China
http://wiki.rockinchina.com/
http://www.rockinchina.com/