Hello,
2017-12-01 20:01 GMT+01:00 Michel Figgins <mfigg...@atlasallied.com>:
> Yes please on the explanation.
>
> When I use mysqldump –hex-blob , the RestoreObject field/column has the
> null byte equivalents (i.e. it starts with 0x3C0042004100 which is “<BA” )
> which I haven’t figured out how to decode.
>
So, use a "decode" function for that. :)
The example how it should looks like is as follow:
insert into restoreobject values (2088,'job_metadata.xml',decode('
3C004200410043004B00550050005F0043004F004D0050004F004E004500
4E0054005300200078006D006C006E0073003D00220078002D0073006300
680065006D0061003A00230056007300730043006F006D0070006F006E00
65006E0074004D0065007400610064006100740061002200200076006500
7200730069006F006E003D00220031002E0032002200200062006F006F00
7400610062006C006500530079007300740065006D005300740061007400
65004200610063006B00750070003D002200790065007300220020007300
65006C0065006300740043006F006D0070006F006E0065006E0074007300
3D002200790065007300220020006200610063006B007500700054007900
700065003D00220069006E006300720065006D0065006E00740061006C00
220020007000610072007400690061006C00460069006C00650053007500
700070006F00720074003D0022006E006F002200200073006E0061007000
730068006F007400530065007400490064003D0022003900330064006100
38003200630066002D0061003300650065002D0034006300620036002D00
61003800320033002D003200630066003000320032003100640039003600
6400380022002F003E000000','hex'),'job',462,462,1506024766,25,596,26229,0);
I hope it helps.
best regards
--
Radosław Korzeniewski
rados...@korzeniewski.net
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
