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

Re: [Bacula-users] PostgreSQL - how to exclude bacula database?

2012-12-28 Thread Dan Langille
On Dec 28, 2012, at 6:12 AM, Jérôme Blion wrote: > Le 2012-12-28 11:19, lst_ho...@kwsoft.de a écrit : >> Zitat von Dan Langille : >> >>> On Dec 27, 2012, at 8:40 PM, Jérôme Blion wrote: >>> You can use pg_dump to backup databases separately. (as far as I know, the pg_dump creates

Re: [Bacula-users] PostgreSQL - how to exclude bacula database?

2012-12-28 Thread Wolfgang Denk
Dear Dan, In message you wrote: > > > However, none of the PostgreSQL based examples I have seen so far > > contain similar (at least similar obvious) exclude rules. What am I > > missing here? > > It depends on where your PostgreSQL database is. On FreeBSD, which is = > my preferred > operati

Re: [Bacula-users] PostgreSQL - how to exclude bacula database?

2012-12-28 Thread Wolfgang Denk
Dear Jérôme Blion, In message <57d402d951b7313f52d27fca670c7...@imap.free.fr> you wrote: > > >> Say what? mysqldump doesn't produce a valid backup? ... > http://dba.stackexchange.com/questions/6363/consistent-logical-backup-of-databases-that-use-myisam-and-innodb-engines > http://dev.mysql.com/do

Re: [Bacula-users] PostgreSQL - how to exclude bacula database?

2012-12-28 Thread Jérôme Blion
Le 2012-12-28 11:19, lst_ho...@kwsoft.de a écrit : > Zitat von Dan Langille : > >> On Dec 27, 2012, at 8:40 PM, Jérôme Blion wrote: >> >>> You can use pg_dump to backup databases separately. (as far as I >>> know, >>> the pg_dump creates consistent backup by defaults, whereas >>> mysqldump >>> do

Re: [Bacula-users] PostgreSQL - how to exclude bacula database?

2012-12-28 Thread lst_hoe02
Zitat von Dan Langille : > On Dec 27, 2012, at 8:40 PM, Jérôme Blion wrote: > >> You can use pg_dump to backup databases separately. (as far as I know, >> the pg_dump creates consistent backup by defaults, whereas mysqldump >> does not by default) > > > Say what? mysqldump doesn't produce a vali