[Mediawiki-l] MySQL Backup and Encodings
matsch at rockinchina.com
Sat Jun 14 09:24:46 UTC 2008
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.
(Both should be the same. The page definitely exists.)
Most tables in the db are of type InnoDB and have the collation
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
Any hints are welcome!
Rock in China
More information about the MediaWiki-l