Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

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

Leonsoft's profile image Leonsoft posted 8 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.