Tom's blog

When you update your ubuntu to 10.04, the upgrade process forgets to update the bacula database which ends with this in bacula logs : 02-May 17:39 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 12, got 10 02-May 17:39 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula". 02-May 17:39 bacula-dir JobId 0: Fatal error: Version error for database "bacula". Wanted 12, got 10 02-May 17:39 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf to correct this you need to run manuall two SQL scripts to upgrade the database (extracted from sources of bacula). First you need to edit ~/.my.cnf so that 'mysql' command use this file to connect to the database : [client] user=root password=YOU_MYSQL_ROOT_PWD_HERE protocol=tcp or change the scripts so that this line : if $bindir/mysql $* -f <<END-OF-DATA is changed to this line : if...

Today I need to purge my bacula for several reasons. Here is how I did. First backup the database and files used in your previous setup, one never knows you might actually need it after the purge... /usr/bin/mysqldump -aecqQ bacula > bacula_before_purge.sql and copy the volumes and bsr files. Stop bacula : service bacula-director stop service bacula-fd stop service bacula-sd stop then : mysql -u root -p drop database bacula; create database bacula; quit next we need to recreate bacula tables. There's a bacula script to do that, but the file needs to be changed to set the correct database name. cp /usr/share/bacula-director/make_mysql_tables ~/ vi ~/make_mysql_tables change XXX_DBNAME_XXX by your bacula database (let's say 'bacula') save and exit. then run as root the script ~/make_mysql_tables it should have recreated the tables : mysql -u root -p use bacula; show tables; +------------------+ | Tables_in_bacula | +-----------...