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