Hi,

I wonder is there a simple way to verify that Bacula's MySQL tables are as
expected by Bacula.

I was running Ubuntu Hardy on our main backup server but needed v3
(primarily for VSS).  I took a cut of the Debian maintainer's git archive
and created and installed packages for v3.0.2.  Now that the new LTS
release, Ubuntu Lucid, is available with Bacula v5 available, I decided to
upgrade.  The dbconfig-common script gave a complaint during upgrade:

mysql said: ERROR 1091 (42000) at line 3: Can't DROP 'Copy'; check that 
column/key exists

So I wasn't sure if the script ran cleanly to upgrade the database tables.
  
  ERROR 1091 (42000) at line 3: Can't DROP 'Copy'; check that column/key exists
  ERROR 1060 (42S21) at line 4: Duplicate column name 'HasCache'
  ERROR 1060 (42S21) at line 5: Duplicate column name 'Reviewed'
  ERROR 1060 (42S21) at line 6: Duplicate column name 'Comment'
  ERROR 1060 (42S21) at line 7: Duplicate column name 'HasCache'
  ERROR 1060 (42S21) at line 8: Duplicate column name 'Reviewed'
  ERROR 1060 (42S21) at line 9: Duplicate column name 'Comment'
  ERROR 1060 (42S21) at line 11: Duplicate column name 'Severity'
  ERROR 1050 (42S01) at line 19: Table 'PathHierarchy' already exists
  ERROR 1061 (42000) at line 26: Duplicate key name 'pathhierarchy_ppathid'
  ERROR 1050 (42S01) at line 29: Table 'PathVisibility' already exists
  ERROR 1061 (42000) at line 37: Duplicate key name 'pathvisibility_jobid'
  ERROR 1061 (42000) at line 40: Duplicate key name 'basefiles_jobid_idx'
  Update of Bacula MySQL tables succeeded.

At a guess, these indicate that the script has already run.  I'm just keen
to verify that everything is now as it should be, rather than find out when
I start getting strange errors and problems with Bacula.

Is there some straightforward way to check the database schema?

Gavin


------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users