6.02.2014 г.

Бекъп ресторе на firebird base.

#! /bin/bash
#Proverqva dali si root
if [ "$(id -u)" != "0" ];then
echo "Trqbva da si root za da stane"
exit 1
fi
#Pita dali da pravi backup ili restore!!!!!
read -p "KAKAVO SHTE PRAVISH? b-za Backup r-za Restore (b/r)" VAPROS
if [ "$VAPROS" = "b" ]; then
#Zapitvane za restart na firebird-a
echo -------------------------------------------------------
read -p "ISKASH LI DA RESTARTIRASH FIREBIRD-A? y-za Da n- Za Ne (y/n)" FIREBIRD
echo -------------------------------------------------------
if [ "$FIREBIRD" = "y" ]; then
echo "SHTE SE RESTATIRA FIREBIRD-A WHAIT!!!"
res=`/etc/init.d/firebird2.5-super restart`
echo $res &&
ping -c 5 127.0.0.1
else
echo "Nama da se restartira firebirda"
fi
#Zapitvane za izbor na baza za backup
echo --------------------------------------------------------
echo "ZADADENIQT PAT E! /home/user/base/firebird.fdb"
echo -------------------------------------------------------
read -p  "IZPOLZVAI OSNOVNIQT PAT ILI NAPISHI NOV!!!: y-za SASHTIQ n- za NOV (y/n)" RESP
if [ "$RESP" = "y" ]; then
echo "Izbra zadadeniqt pat"
realpat="/home/user/base/firebird.fdb"
cp -p /home/user/base/firebird.fdb "/home/user/base/backupdir/firebird-`date`.fdb" &&
gbak -t -v -user SYSDBA -password masterkey "$realpat" /home/user/base/firebird.fbk &&
chown user.user /home/user/base/firebird.fbk
else
echo "Vavedi patq do bazata na fdb-to"
read pat
cp -p "$pat" "/home/user/base/backupdir/firebird-`date`.fdb" &&
gbak -t -v -user SYSDBA -password masterkey "$pat" /home/user/base/firebird.fbk &&
chown user.user /home/user/base/firebird.fbk
fi
else
echo "Shte pravi restore, napravi restart na firebirda!!!"
read -p "ISKASH LI DA RESTARTIRASH FIREBIRD-A? y-za Da n- Za Ne (y/n)" RESFIREBIRD
echo -------------------------------------------------------
if [ "$RESFIREBIRD" = "y" ]; then
echo "SHTE SE RESTATIRA FIREBIRD-A WHAIT!!!"
res=`/etc/init.d/firebird2.5-super restart`
echo $res &&
ping -c 5 127.0.0.1
else
echo "Nama da se restartira firebirda"
fi
#Zapitvane za izbor na baza za restore
echo --------------------------------------------------------
echo "ZADADENIQT PAT E! /home/user/base/firebird.fbk"
echo -------------------------------------------------------
read -p  "IZPOLZVAI OSNOVNIQT PAT ILI NAPISHI NOV!!!: y-za SASHTIQ n- za NOV (y/n)" RESTORERESP
if [ "$RESTORERESP" = "y" ]; then
echo "Izbra zadadeniqt pat"
realpatres="/home/user/base/firebird.fbk"
mv /home/user/base/firebird.fdb "/homeuser/base/backupdir/firebird-`date`.fdb" &&
gbak -c -v -user SYSDBA -password masterkey "$realpatres" /home/user/base/firebird.fdb &&
chown user.user /home/user/base/firebird.fdb &&
chmod 777 /home/user/base/firebird.fdb &&
echo "OK"
else
echo "Vavedi patq do bazata na fbk-to"
read pat
mv /home/user/base/firebird.fdb "/home/user/base/backupdir/firebird-`date`.fdb" &&
gbak -t -v -user SYSDBA -password masterkey "$pat" /home/user/base/firebird.fdb &&
chown user.user /home/user/base/firebird.fdb &&
chmod 777 /home/user/base/firebird.fdb &&
echo "OK"
fi
fi

Няма коментари :

Публикуване на коментар