On 02.02.2011 06:21, Marcin Cieslak wrote:
River Tarnell r.tarnell@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