Exporting BLOB column wrong (need to specify --hex-blob option)

[expired user #8599]'s profile image [expired user #8599] posted 9 years ago in Import/Export Permalink
I have some blob columns (images), after exporting and importing back to db using HeidiSql, the blob data are not correct anymore.
With --hex-blob option with mysqldump tool,
mysqldump -u pkm -p test1 --hex-blob > d:\temp\test.sql
then import test.sql with HeidiSql, blob data are the same as before exporting.

So we need the ability to specify --hex-blob option within Heidisql too.

I'm running Heidisql 9 on windows 7, Chinese system.

Please login to leave a reply, or register at first.