Bug #11058 mysqldump does not preserve database
Submitted: 3 Jun 2005 0:51 Modified: 3 Jun 2005 11:48
Reporter: Lachlan Mulcahy Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S2 (Serious)
Version:4.1.x OS:Any (Any)
Assigned to: Sergei Golubchik CPU Architecture:Any

[3 Jun 2005 0:51] Lachlan Mulcahy
Description:
It seems as though mysqldump is having a problem -- it's incorrectly converting some binary data which can easily cause data corruption after a dump & restore.

How to repeat:
See internal info.

Suggested fix:
Ensure mysqldump preserves this kind of data in a dump/restore.
[3 Jun 2005 11:48] Sergei Golubchik
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

If you want to store binary data, you have to use binary data type, e.g. BLOB.