taken from http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html:
--default-character-set=charset_name
Use charset_name as the default character set. See Section 5.11.1, “The
Character Set Used for Data and Sorting”. If not specified, mysqldump
uses utf8.
and
--character-sets-dir=path
The directory where character sets are installed. See Section 5.11.1,
“The Character Set Used for Data and Sorting”.
If you know where your character sets are stored simply use the latter
option and point mysqldump directly to it. The only thing I can think
of otherwise is that either binary isn't actually a supported character
set or you don't have it set as a configured option.
Mathew
Mike Friedman wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Fri, 18 Aug 2006 at 19:55 (-0400), Mathew Snyder wrote:
I haven't seen any documentation on the 'default binary' option,
which is why I'm asking here. If I ever have to restore one of my
current backups, it would be nice to know that binary attachments
weren't corrupted.
So, should I change my current dumps to use the binary option?
The only thing I could recommend is to try it both with and without
the option during your testing before actually doing the migration.
Mathew,
I just tried specifying '--default-character-set=binary', but this
wasn't accepted. I got the following message instead of a dump:
Usage: mysqldump [OPTIONS] database [tables]
OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help
This is mysql 5.0.22-1 on Linux (Fedora (FC5)).
In the mysql manual, although I see the '--default-character-set' option
documented, there's no mention of 'binary' as a valid value. What am I
missing here?
Thanks.
Mike
_________________________________________________________________________
Mike Friedman IST/System and Network Security
[EMAIL PROTECTED] 2484 Shattuck Avenue
1-510-642-1410 University of California at Berkeley
http://socrates.berkeley.edu/~mikef http://security.berkeley.edu
_________________________________________________________________________
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8
iQA/AwUBROnbua0bf1iNr4mCEQJaUQCgjj4+7Xheq9hfqq90EvNYnHOWiRwAoO2p
9i1HlqrsThxQf6QTdD6edUAW
=EzsR
-----END PGP SIGNATURE-----
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com