#!/bin/bash

user=secret
pass=secret
dbfile='/var/lib/firebird/2.5/data/rsgdata.gdb'
dbname=$(mktemp -u)

echo $dbname
echo "Stopping firebird..."
service firebird2.5-super stop
echo "Copying database..."
cp -f $dbfile /tmp/${dbname}.orig.gdb
echo "Starting firebird..."
service firebird2.5-super start
echo "Locking database..."
gfix -user $user -password $pass localhost:rsgdata -shut single -force 5
echo "Backing up database..."
gbak -b localhost:rsgdata ${dbname}.bak.orig.gdb -user $user -pas $pass
echo "Restoring database..."
gbak -rep ${dbname}.bak.orig.gdb localhost:rsgdata -user $user -pas $pass