Bacula-users

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

2012-12-28 16:04:52
Subject: Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails
From: Wolfgang Denk <wd AT denx DOT de>
To: Bryan Harris <bryanlharris AT me DOT com>
Date: Fri, 28 Dec 2012 22:02:03 +0100
Dear Bryan,

In message <29D76671-F52F-403B-928A-BF6126972537 AT me DOT 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 in
statements like

        INSERT INTO `File` VALUES (1422233176,1941692,37890,1487195,...
                    ^

But I get the same error message when changing the ` into ' like that:

        INSERT INTO 'File' VALUES (1422233176,1941692,37890,1487195,...

So there must be some other problem...

Hm.... google tells me about some "--compatible=postgresql" argument
to mysqldump ...

Will try that.  But then - why isn't this mentioned anywhere in the
bacula docs?

Best regards,

Wolfgang Denk

-- 
DENX Software Engineering GmbH,     MD: Wolfgang Denk & Detlev Zundel
HRB 165235 Munich, Office: Kirchenstr.5, D-82194 Groebenzell, Germany
Phone: (+49)-8142-66989-10 Fax: (+49)-8142-66989-80 Email: wd AT denx DOT de
"When the only  tool  you  have  is  a  hammer,  you  tend  to  treat
everything as if it were a nail."                    - Abraham Maslow

------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users