It has been discussed on this list and on the web site that the
mysqldump behavior has changed from 4.0 to 4.1, and now converts all
data from the character set of the data to the default-character-set
(which is utf8 by default).
So my question is: how does one reliably use mysqldump to back up a
table that contains multiple character sets, since one of the fields
will invariably encounter a conversion. Is there an undocumented
option that functions as "--binary-charset" ? or are we just left
with no way to backup and restore a table with mysqldump anymore? I
suppose the same would have to apply to mysql as well for restoring said file.
Note, "select into outfile" appears to dump without conversion, but I
hate to rewrite all my backup scripts, since this requires access to
the server filesystem as well.
Thanks.
-Mike
===========================================================
Michael Gile [EMAIL PROTECTED]
President (518)435-0682
Web Services Group http://www.wsg.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
