Hello,
2017-12-01 20:01 GMT+01:00 Michel Figgins :
> 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 “ which I haven’t figured out how to decode.
>
So, use a "decode" f
Hello,
2017-11-30 17:14 GMT+01:00 Wanderlei Huttel :
> Hello Radoslaw
>
> Could you explain better about "mysqldump --hex-blob"?
>
>
The default mysqldump will export any blob in the form which cannot be used
to import it into a postgresql. It looks something like this:
INSERT INTO RestoreObject
; bacula-users
Subject: Re: [Bacula-users] Errors migrating from mysql to postgres
Hello Radoslaw
Could you explain better about "mysqldump --hex-blob"?
Maybe I could include in the script and improve for not happen any errors.
Best regards
Wanderlei Hüttel
http://www.huttel.com.br
2017-
Hello Radoslaw
Could you explain better about "mysqldump --hex-blob"?
Maybe I could include in the script and improve for not happen any errors.
Best regards
*Wanderlei Hüttel*
http://www.huttel.com.br
2017-11-30 9:10 GMT-02:00 Radosław Korzeniewski :
> Hello,
>
> 2017-11-28 11:55 GMT+01:00 W
Hello,
2017-11-30 12:10 GMT+01:00 Radosław Korzeniewski
:
> Hello,
>
> 2017-11-28 11:55 GMT+01:00 Wanderlei Huttel :
>
>> Hello Michel
>>
>> I've created some scripts to do this job.
>> https://github.com/wanderleihuttel/bacula-utils/tree/master/
>> convert_mysql_to_postgresql
>>
>> I only had s
Hello,
2017-11-28 11:55 GMT+01:00 Wanderlei Huttel :
> Hello Michel
>
> I've created some scripts to do this job.
> https://github.com/wanderleihuttel/bacula-utils/
> tree/master/convert_mysql_to_postgresql
>
> I only had some troubles with the Log table, but I've changed some
> registries manual
Hello Michel
I've created some scripts to do this job.
https://github.com/wanderleihuttel/bacula-utils/tree/master/convert_mysql_to_postgresql
I only had some troubles with the Log table, but I've changed some
registries manually and everything worked fine.
A guy in Brazil with a database with 6g
> On Mon, 27 Nov 2017 19:13:15 +, Michel Figgins said:
>
> Hello,
> I'm trying to migrate from a mysql backend to a postgresql backend and
> I'm getting an error importing the RestoreObject table. Specifically I'm
> getting :
> ERROR: invalid input syntax for type bytea
> LINE 1:
>> -Original Message-
>> From: Dan Langille [mailto:d...@langille.org]
>> Sent: Monday, November 27, 2017 1:29 PM
>> To: Michel Figgins
>> Cc: bacula-users
>> Subject: Re: [Bacula-users] Errors migrating from mysql to postgres
>>
>&
-users] Errors migrating from mysql to postgres
> On Nov 27, 2017, at 2:13 PM, Michel Figgins wrote:
>
> Hello,
> I'm trying to migrate from a mysql backend to a postgresql backend and
> I'm getting an error importing the RestoreObject table. Specifically I'm
> On Nov 27, 2017, at 2:13 PM, Michel Figgins wrote:
>
> Hello,
> I'm trying to migrate from a mysql backend to a postgresql backend and
> I'm getting an error importing the RestoreObject table. Specifically I'm
> getting :
> ERROR: invalid input syntax for type bytea
> LINE 1: ...bject
Hello,
I'm trying to migrate from a mysql backend to a postgresql backend and
I'm getting an error importing the RestoreObject table. Specifically I'm
getting :
ERROR: invalid input syntax for type bytea
LINE 1: ...bjectCompression) VALUES (1588,'job_metadata.xml',' bacula-export.sql
Th
12 matches
Mail list logo