# The location of your bacula working directory
cd /var/bacula
+if [ -s bacula.db ];then
+ DB_VER=`echo "select * from Version;" | $bindir/sqlite bacula.db | tail -n 1 2>/dev/null`
+ if [ -n "$DB_VER" ] && [ "$DB_VER" -ne "6" ]; then
+ echo "Sorry, this script is designed to update a version 6 database"
+ echo "and you have a version $DB_VER database."
+ exit 1
+ fi
+else
+ echo "Sorry, I can't seem to locate a bacula database."
+ exit 1
+fi
+
$bindir/sqlite $* bacula.db <<END-OF-DATA
BEGIN TRANSACTION;
VolRetention, VolUseDuration, MaxVolJobs,
MaxVolFiles, MaxVolBytes,
InChanger, MediaAddressing,
- VolReadTime, VolWriteTime,
+ VolReadTime, VolWriteTime)
SELECT * FROM Media_backup;
DROP TABLE Media_backup;