Just a long shot, but did you try dos2unix?
Bryan
On Dec 28, 2012, at 11:06 AM, Wolfgang Denk <wd AT denx DOT de> 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/catalog/Installi_Configur_PostgreS.html
> especially section "Converting from MySQL to PostgreSQL".
>
> However, when trying to run the commands exported by MySQL, I get a
> ton of syntax errors:
>
> ERROR: syntax error at or near "`"
> LINE 1: LOCK TABLES `BaseFiles` WRITE;
> ^
> ERROR: syntax error at or near "UNLOCK"
> LINE 1: UNLOCK TABLES;
> ^
> ERROR: syntax error at or near "`"
> LINE 1: LOCK TABLES `CDImages` WRITE;
> ^
> ERROR: syntax error at or near "UNLOCK"
> LINE 1: UNLOCK TABLES;
> ^
> ERROR: syntax error at or near "`"
> LINE 1: LOCK TABLES `Client` WRITE;
> ^
> ERROR: syntax error at or near "`"
> LINE 1: INSERT INTO `Client` VALUES (1,'diddl-fd','5.2.12 (12Sep12) ...
> ^
> ERROR: syntax error at or near "UNLOCK"
> LINE 1: UNLOCK TABLES;
> ^
> ERROR: syntax error at or near "`"
> LINE 1: LOCK TABLES `Counters` WRITE;
> ^
> ERROR: syntax error at or near "UNLOCK"
> LINE 1: UNLOCK TABLES;
> ^
> ERROR: syntax error at or near "`"
> LINE 1: LOCK TABLES `Device` WRITE;
> ^
> ERROR: syntax error at or near "UNLOCK"
> LINE 1: UNLOCK TABLES;
> ^
> ERROR: syntax error at or near "`"
> LINE 1: LOCK TABLES `File` WRITE;
> ^
> ERROR: syntax error at or near "`"
> LINE 1: INSERT INTO `File` VALUES (1422233176,1941692,37890,1487195,...
> ^
> ERROR: syntax error at or near "`"
> LINE 1: INSERT INTO `File` VALUES (1406866989,2278503,37516,1674162,...
> ^
> ERROR: syntax error at or near "`"
> LINE 1: INSERT INTO `File` VALUES (1405758742,1170256,37516,907380,2...
> ^
> ERROR: syntax error at or near "`"
> LINE 1: INSERT INTO `File` VALUES (1405736710,1148224,37516,935293,1...
> ^
> ERROR: syntax error at or near "`"
> LINE 1: INSERT INTO `File` VALUES (1405744738,1156252,37516,935661,1...
> ^
> ERROR: syntax error at or near "`"
> LINE 1: INSERT INTO `File` VALUES (1414375645,393904,37886,7163,1817...
> ^
> ...
>
> It appears that the file formats are not compatible. Is there
> anything I'm missing, or some simple fix (like substituting all "`"
> charatcers with "'" or so) ?
>
> 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
> Until you walk a mile in another man's moccasins, you can't imagine
> the smell.
>
> ------------------------------------------------------------------------------
> 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
------------------------------------------------------------------------------
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
|