Hello,
2017-11-30 12:10 GMT+01:00 Radosław Korzeniewski <rados...@korzeniewski.net>
:
> Hello,
>
> 2017-11-28 11:55 GMT+01:00 Wanderlei Huttel <wanderleihut...@gmail.com>:
>
>> 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 6gb used these scripts and had no
>> problems
>>
>
And the database was 24GB in size.
>
> I have migrated a Bacula 5.x to 7.x from MySQL into a PostgreSQL and I had
> the same problem with RestoreObjects table. The solution was to use:
> --hex-blob parameter to mysqldump and use a decode() function from
> PostgreSQL.
> The Restore Objects table is populated when Bacula run a Windows VSS
> backup. If you backup all but Windows VSS you will have no problem with
> above script. :)
>
> The next problem I encountered was an ' character in some filenames which
> mysqldump is unable to proper escape, even with --compatible=postgresql
> option. So I had to escape it manually (with an additional script).
>
> Finally the migration was successful but due to above errors it took more
> time then expected.
>
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
