On 02.02.2011 06:21, Marcin Cieslak wrote:
>> River Tarnell <r.tarnell(a)IEEE.ORG>
wrote:
>
>> Are there any subtle options that need to be set on mysqldump to make
>> sure the output is usable in that environment?
>
> In previous versions of MySQL it was necessary to use 'mysqldump
> --default-character-set=latin1' if you had tables marked as Latin-1
> which actually contained UTF-8 data. Otherwise, the dump would be
> corrupted and unusable.
Use --default-character-set BINARY for export with mysqldump *and* for import
with the mysql client. This should preserve your original data, no matter what.
-- daniel