Bacula-users

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

2012-12-30 04:48:27
Subject: Re: [Bacula-users] PostgreSQL: import of DB from MySQL fails
From: Wolfgang Denk <wd AT denx DOT de>
To: Andrea Conti <alyf AT alyf DOT net>
Date: Sun, 30 Dec 2012 10:45:36 +0100
Dear Andrea,

thanks for your help.

In message <50DEB974.1070709 AT alyf DOT net> you wrote:
> > Hm... with "--compatible=postgresql" the backtics get changed into '"'
> > characters, but the errors essentially remain the same:
> > 
> > ERROR:  syntax error at or near ""BaseFiles""
> > LINE 1: LOCK TABLES "BaseFiles" WRITE;
> >                     ^
> > ERROR:  syntax error at or near "UNLOCK"
> > LINE 1: UNLOCK TABLES;
> 
> Postgres has a different syntax for the LOCK command, and has no UNLOCK.
> You can safely remove LOCK/UNLOCK commands as they're not needed in this
> scenario.

It appears there are more differences...

> > ERROR:  relation "Client" does not exist
> > LINE 1: INSERT INTO "Client" VALUES (1,'diddl-fd','5.2.12 (12Sep12) ...
> 
> You must create the tables before inserting data. You can either tell
> mysqldump to also dump the db schema (but you will have to review the
> CREATE TABLE statements as there are differences in type names) or
> create the schema using the postgres SQL script which comes with bacula.

I did create the tables before - I followed the instructions and ran
the commands

        ./drop_bacula_tables
        ./make_bacula_tables
        ./grant_bacula_privileges

before attempting the DB import.

> Depending on your setup, you could also consider creating an empty
> database and bscanning all existing volumes into it.

This is not really an option for me.  I have >700 tapes (including a
large number of old, slow SLR100 and DDS-3 tapes) in 2 databases.
Scanning these tapes would take ages and cause a significant amount of
manual interaction.

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
"It is better for civilization to be going down the drain than to  be
coming up it."                                          - Henry Allen

------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_123012
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users