On 02.02.2011 06:21, Marcin Cieslak wrote: >>> River Tarnell <[email protected]> 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 _______________________________________________ Toolserver-l mailing list ([email protected]) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
