3 # Shell script to update MySQL tables from version 2.0 to 3.0
6 echo "This script will update a Bacula MySQL database from version 10 to 11"
7 echo " which is needed to convert from Bacula version 2.0.x to 3.0.x or higher"
12 if $bindir/mysql $* -f <<END-OF-DATA
15 -- Create a table like Job for long term statistics
16 CREATE TABLE JobStat (LIKE Job);
19 INSERT INTO Version (VersionId) VALUES (11);
23 echo "Update of Bacula MySQL tables succeeded."
25 echo "Update of Bacula MySQL tables failed."