mysqldump "hex-blob" option

mysqldump "hex-blob" option

am 05.03.2010 04:21:19 von pengyao

--00504502e3f78b5f2d0481053556
Content-Type: text/plain; charset=UTF-8

hello erveryone, I have a question about mysqldump.I have some blob data,
someone tell me mysqldump the data must use "hex-blob" options, why?

--00504502e3f78b5f2d0481053556--

Re: mysqldump "hex-blob" option

am 08.03.2010 15:50:49 von Barry Leslie

On 3/4/10 7:21 PM, "peng yao" wrote:

> hello erveryone, I have a question about mysqldump.I have some blob data,
> someone tell me mysqldump the data must use "hex-blob" options, why?

mysqldump just creates a file containing insert statements that when
executed rebuild your tables. As a result, this file cannot contain binary
data and so BLOBs must be converted to hex. If you know your BLOBs are just
text then you can get away with out the "hex-blob" option.


Barry Leslie




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org