Restore the binary file into MySQL

[tom_sri74]

How to restore the binary file (JBPM_BYTEBLOCK)

I did jbpm backup using the below syntax

mysqldump -u -p --database jbpm > dbname.sql

When I use restore using source as below command

mysql> source dbname.sql;

It's create insert except JBPM_BYTEBLOCK TABLE

But issue only to execute the some binary data script. Mysql doesn't recognize the binary data for insert.

For eg: jbpm_byteblock table -- > Field BYTES -- > Type blob
The above fields are binary data.

Anybody can give the solutions how to restore the binary file?

[tom_sri74]

Hi guys,

Please any body can response my issue! I am stuck this issue.

Regards

[kukeltje]

I think it is better to ask this in the mysql forum, since you use mysql commandline tools