[Mediawiki-l] Site mirror or copy

Brion Vibber 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 

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 mailing list