3 # Shell script to update MySQL tables from version 1.34 to 1.35.5
6 echo "This script will update a Bacula MySQL database from version 7 to 8"
7 echo "Depending on the size of your database,"
8 echo "this script may take several minutes to run."
10 bindir=/home/kern/bacula/depkgs/sqlite
12 if $bindir/mysql $* -f <<END-OF-DATA
15 ALTER TABLE Media ADD COLUMN EndFile INTEGER UNSIGNED NOT NULL DEFAULT 0;
16 ALTER TABLE Media ADD COLUMN EndBlock INTEGER UNSIGNED NOT NULL DEFAULT 0;
18 UPDATE Filename SET Name='' WHERE Name=' ';
21 INSERT INTO Version (VersionId) VALUES (8);
25 echo "Update of Bacula MySQL tables succeeded."
27 echo "Update of Bacula MySQL tables failed."