Just a long shot, but did you try dos2unix? Bryan
On Dec 28, 2012, at 11:06 AM, Wolfgang Denk <w...@denx.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: w...@denx.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@lists.sourceforge.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
