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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users