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
>
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
