backup.sh

#!/bin/bash
# Backup database postgres (SIAKAD AKPER Luwuk)
# Author Yusuf Ayuba ([email protected])

# inisial variabel
tgl=$(date +'%H:%M:%S_%d-%m-%Y')
username=<username database>
dbname=<db name>
folderBackup=<folder temporary backup>
fileBackup="backup_"$tgl".sql.gz"
folderYii=<folder yii>

# proses backup
clear
echo "====================================================="
echo "=              Prosessing backup database           ="
echo "====================================================="
pg_dump -U $username $dbname | gzip > $folderBackup"/"$fileBackup

if [ -e $folderBackup"/"$fileBackup ]; then
        clear
        cd $folderYii
        php yii backup-database $fileBackup
        echo "=================================================================="
        echo "=                   Database berhasil dibackup.                  ="
        echo "=           File dalam antrian untuk disimpan di Cloud           ="
        echo "=================================================================="
        echo ""
        exit 1
fi