[Mediawiki-l] Site mirror or copy
brion at pobox.com
Tue Oct 24 03:13:22 UTC 2006
Mauro do Carmo wrote:
> Those configurations about Collation utf8, or utf8 bin, or latin, etc. are really problematic... and I am afraid of not being doing
> the right kind of dumping for backup.
> I was dumping my Database, and after importing it to a different DB_. After that, I was getting problems with my collation... my
> accentuations was completely odd what caused several broken links.
For a dedicated MediaWiki system I would recommend using MySQL 4.0, as
we do, which doesn't have this problem. :)
If for some reason that's not an option, just be very careful with your
mysqldump options. By default in 4.1 and higher, mysqldump performs
LOSSY CONVERSION WHICH CAN CORRUPT YOUR DATA.
Set it specifically to output in the same charset as your database is
set to to avoid this. I believe the option is called --charset or
--default-charset; pass the appropriate value to match.
-- brion vibber (brion @ pobox.com)
More information about the MediaWiki-l