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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
