Am Sun, 28 Feb 2010 11:42:59 -0300 schrieb Daniel Bareiro: > Hi all! > > I'm trying to update the database tables of Bacula 3.0.2 using the > script update_bacula_tables, but when doing I obtain it the following > errors: > > --------------------------------------------------------------------- > backup:/etc/bacula/scripts# ./update_bacula_tables Altering MySQL tables > > This script will update a Bacula MySQL database from version 11 to 12 > which is needed to convert from Bacula Enterprise 2.6 to 4.0 or > Standard version 3.0 to 5.0 > > ERROR 1091 (42000) at line 3: Can't DROP 'Stripe'; check that column/key > exists ERROR 1050 (42S01) at line 20: Table 'PathHierarchy' already > exists ERROR 1061 (42000) at line 27: Duplicate key name > 'pathhierarchy_ppathid' ERROR 1050 (42S01) at line 30: Table > 'PathVisibility' already exists ERROR 1061 (42000) at line 38: Duplicate > key name 'pathvisibility_jobid' Update of Bacula MySQL tables succeeded. > --------------------------------------------------------------------- > > Which can be the problem? I would have to use another procedure?
IMHO these don't seem to be "error" messages. it tries to delete a column but it doesn't exist. it tries to create new tables, but they already exist. tries to create a new index, but it already exists. maybe you ran it twice? i would say: all is fine. - Thomas ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users