So this command should use --default-character-set=binary, then, and not --default-character-set=utf8 ?
mysqldump -h hostname -u userid -ppassword --default-character-set=binary dbname > backup.sql
On 1/27/2013 12.49, Amir E. Aharoni wrote:
2013/1/27 Steve VanSlyck s.vanslyck@spamcop.net:
Hi. If MediaWiki prefers utf-8. My server admint installed mediawiki and didn't follow the instructions precisely so I now have
# MySQL table options to use during installation or update $wgDBTableOptions = "ENGINE=InnoDB, DEFAULT CHARSET=binary";
The short answer is that this is fine: This is the default and it allows storing UTF-8 text, and it's even supposed to offer better performance.
If I knew MySQL properly, I'd give you the long answer, too :)
People who do know MySQL are welcome to correct me if I'm wrong.
-- Amir Elisha Aharoni · אָמִיר אֱלִישָׁע אַהֲרוֹנִי http://aharoni.wordpress.com “We're living in pieces, I want to live in peace.” – T. Moore
Is there an easy way to convert from binary to UTF-8?
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l