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)