2 Replies Latest reply on Oct 16, 2006 4:40 AM by Ronald van Kuijk

    Restore the binary file into MySQL

    Srikanth Ramaswamy Newbie

      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?