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 <[email protected]>:
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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
