Bacula-users

[Bacula-users] Migrating from MySQL to Postgres

2015-06-29 10:08:28
Subject: [Bacula-users] Migrating from MySQL to Postgres
From: tballin <t.ballin AT studiorakete DOT de>
To: bacula-users AT lists.sourceforge DOT net
Date: Mon, 29 Jun 2015 15:47:37 +0200
Hi

I try to migrate from am mysql db to postgres. I am failing to import 
thy mysql dump into the postrgres :
(according to these instructions:
http://www.bacula.org/7.0.x-manuals/en/main/Installing_Configuring_Post.html#SECTION004150000000000000000
bacula 7.1 / CentOS )
lots of
psql:/tmp/bacula-backup2pg.sql:46485014: invalid command 
\'].sublime-snippet');
psql:/tmp/bacula-backup2pg.sql:46485018: invalid command 
\'].sublime-snippet');
psql:/tmp/bacula-backup2pg.sql:46485025: invalid command 
\'].sublime-snippet');
psql:/tmp/bacula-backup2pg.sql:46485027: invalid command 
\'].sublime-snippet');
psql:/tmp/bacula-backup2pg.sql:46485042: invalid command 
\'].sublime-snippet');
psql:/tmp/bacula-backup2pg.sql:46485194: invalid command 
\'-Marker.sublime-snippet');
psql:/tmp/bacula-backup2pg.sql:62088431: out of memory

The point is - I do not need really the big file table (33M+ rows) since 
we will start the migration - or better finish the migration with a new 
full backup and could keep the old mysql until no longer needed.

But I would like to keep as much information as possible. e.g. the 
volume labels/pools. Is there a easy way to just do that?

If any one had a good Idea or documentation how to do that I would 
depreciate any help.

Timo



____ ESET 11860 (20150629) ____
The message was checked by ESET Mail Security.


------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors 
network devices and physical & virtual servers, alerts via email & sms 
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>
  • [Bacula-users] Migrating from MySQL to Postgres, tballin <=