Saturday, June 18, 2011

mysqldump and utf8 encoded databases...

I tried everything, but all my dumps where coming in with garbled characters. The solution ended up being:

>mysqldump -r database_full_backup.sql --default-character-set=latin1 --user=USERNAME --password=PASSWORD --opt DATABASE NAME


Note that the expected is -default-character-set=utf8, but this is a known bug I guess.

No comments:

Post a Comment