Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2013-01-06 Thread Dan Langille
On Jan 6, 2013, at 2:16 PM, Wolfgang Denk wrote: > Dear Dan, > > In message <078a8ca8-46cc-46e5-afce-ccfde5644...@langille.org> you wrote: >> >>> But the instructions at >>> http://www.bacula.org/manuals/en/catalog/catalog/Installi_Configur_PostgreS.html >>> simply don't work at all (no surpris

Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2013-01-06 Thread Wolfgang Denk
Dear Dan, In message <078a8ca8-46cc-46e5-afce-ccfde5644...@langille.org> you wrote: > > > But the instructions at > > http://www.bacula.org/manuals/en/catalog/catalog/Installi_Configur_PostgreS.html > > simply don't work at all (no surprise, as these appear to be more than > > 8 years old and ref

Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2012-12-30 Thread Dan Langille
On Dec 30, 2012, at 4:50 AM, Wolfgang Denk wrote: > Dear Dan, > > In message <59739303-6ccd-4198-9f10-135cec184...@langille.org> you wrote: >> >> Yes. Let the Bacula scripts create the PostgreSQL tables, then export only >> data from MySQL. > > This is what I'm trying to do. > > But the inst

Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2012-12-30 Thread Marco van Wieringen
On 12/30/12 10:40 AM, Wolfgang Denk wrote: Dear Marco van Wieringen, In message you wrote: I have no idea what to try next. Any pointers? All help welcome. Maybe try the in 2010 working solution available here http://mtu.net/~jpschewe/blog/2010/06/migrating-bacula-from-mysql-to-postgresql/

Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2012-12-30 Thread Wolfgang Denk
Dear Dan, In message <59739303-6ccd-4198-9f10-135cec184...@langille.org> you wrote: > > Yes. Let the Bacula scripts create the PostgreSQL tables, then export only > data from MySQL. This is what I'm trying to do. But the instructions at http://www.bacula.org/manuals/en/catalog/catalog/Installi

Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2012-12-30 Thread Wolfgang Denk
Dear Andrea, thanks for your help. In message <50deb974.1070...@alyf.net> you wrote: > > Hm... with "--compatible=postgresql" the backtics get changed into '"' > > characters, but the errors essentially remain the same: > > > > ERROR: syntax error at or near ""BaseFiles"" > > LINE 1: LOCK TABLE

Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2012-12-30 Thread Wolfgang Denk
Dear Marco van Wieringen, In message you wrote: > > > I have no idea what to try next. Any pointers? All help welcome. > Maybe try the in 2010 working solution available here > > http://mtu.net/~jpschewe/blog/2010/06/migrating-bacula-from-mysql-to-postgresql/ > > which is way more up to date

Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2012-12-29 Thread Dan Langille
On Dec 29, 2012, at 4:35 AM, Andrea Conti wrote: >> Hm... with "--compatible=postgresql" the backtics get changed into '"' >> characters, but the errors essentially remain the same: >> >> ERROR: syntax error at or near ""BaseFiles"" >> LINE 1: LOCK TABLES "BaseFiles" WRITE; >>

Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2012-12-29 Thread Andrea Conti
> Hm... with "--compatible=postgresql" the backtics get changed into '"' > characters, but the errors essentially remain the same: > > ERROR: syntax error at or near ""BaseFiles"" > LINE 1: LOCK TABLES "BaseFiles" WRITE; > ^ > ERROR: syntax error at or near "UNLOCK" > LINE 1:

Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2012-12-28 Thread Marco van Wieringen
Wolfgang Denk denx.de> writes: > > I have no idea what to try next. Any pointers? All help welcome. Maybe try the in 2010 working solution available here http://mtu.net/~jpschewe/blog/2010/06/migrating-bacula-from-mysql-to-postgresql/ which is way more up to date then anything in the current

Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2012-12-28 Thread Wolfgang Denk
In message <20121228210203.4a8f5200...@gemini.denx.de> I wrote: > > There is no Windows system involved anywhere. All are Linux boxen. > And PostgreSQL appeas to complain about the first backtick in > statements like > > INSERT INTO `File` VALUES (1422233176,1941692,37890,1487195,... >

Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2012-12-28 Thread Wolfgang Denk
Dear Bryan, In message <29d76671-f52f-403b-928a-bf6126972...@me.com> you wrote: > Just a long shot, but did you try dos2unix? No, I didn't (but it doesn't help either). There is no Windows system involved anywhere. All are Linux boxen. And PostgreSQL appeas to complain about the first backtick

Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails

2012-12-28 Thread Bryan Harris
Just a long shot, but did you try dos2unix? Bryan On Dec 28, 2012, at 11:06 AM, Wolfgang Denk wrote: > Hi, > > now that I got the PostgreSQL setup working, I try to import my data > from the old MySQL configuration. I'm following the instructions at > http://www.bacula.org/manuals/en/catalog/

[Bacula-users] PostgreSQL: import of DB from MySQL fails

2012-12-28 Thread Wolfgang Denk
Hi, now that I got the PostgreSQL setup working, I try to import my data from the old MySQL configuration. I'm following the instructions at http://www.bacula.org/manuals/en/catalog/catalog/Installi_Configur_PostgreS.html especially section "Converting from MySQL to PostgreSQL". However, when tr