[Mediawiki-l] Site mirror or copy

[Brion Vibber]

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)