Hi All,
We are in the process of upgrading our installations from 1.13 and 1.9 to 1.15 and we are having a little issue with page titles degrading. When we dump the live database and move it to an acceptance machine and run the upgrade.php script on it we find that the characters like alpha have been changing into less readable strings.
We have tried: mysqldump (with no options) mysqldump --default-character-set=latin1 mysqldump --default-character-set=utf8
We have tried post dump conversion scripts, including Charco (as recommended in the MW Manual.)
Any other pointers would be really helpful.
Thanks, Courtney Christensen
For the backup we use:
mysqldump -u username --password=password --opt --quote-names --default-character-set=latin1 databasename > backupfile.sql
and for the restore we use:
mysql -u username --password=password databasename < backupfile.sql
Hope this helps... -Jim
-----Original Message----- From: Christensen, Courtney [mailto:ChristensenC@battelle.org] Sent: Monday, April 26, 2010 10:12 AM To: MediaWiki announcements and site admin list Subject: [Mediawiki-l] 1.13.2 to 1.15 upgrade on Windows, title character problems
Hi All,
We are in the process of upgrading our installations from 1.13 and 1.9 to 1.15 and we are having a little issue with page titles degrading. When we dump the live database and move it to an acceptance machine and run the upgrade.php script on it we find that the characters like alpha have been changing into less readable strings.
We have tried: mysqldump (with no options) mysqldump --default-character-set=latin1 mysqldump --default-character-set=utf8
We have tried post dump conversion scripts, including Charco (as recommended in the MW Manual.)
Any other pointers would be really helpful.
Thanks, Courtney Christensen
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
The solution to this, crazy though it sounds, seems to be to open the mysqldump'd database file in MS Word and tell Word it is looking at UTF-8.
-Courtney
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Christensen, Courtney Sent: Monday, April 26, 2010 10:12 AM To: MediaWiki announcements and site admin list Subject: [Mediawiki-l] 1.13.2 to 1.15 upgrade on Windows, title character problems
Hi All,
We are in the process of upgrading our installations from 1.13 and 1.9 to 1.15 and we are having a little issue with page titles degrading. When we dump the live database and move it to an acceptance machine and run the upgrade.php script on it we find that the characters like alpha have been changing into less readable strings.
We have tried: mysqldump (with no options) mysqldump --default-character-set=latin1 mysqldump --default-character-set=utf8
We have tried post dump conversion scripts, including Charco (as recommended in the MW Manual.)
Any other pointers would be really helpful.
Thanks, Courtney Christensen
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org