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)