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
|