mkdir -p /home/deploy/cadangandb
nano /home/deploy/dbackup.sh
#
#!/bin/sh

USER="dbackup"
PASSWORD="aid-judicial-misjudge-casket"
OUTPUT="/home/deploy/cadangandb"

rm "$OUTPUT/*gz" > /dev/null 2>&1

databases=`/usr/bin/mysql --user=$USER --password=$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep proxsis_`

for db in $databases; do
    if [[ "$db" != "information_schema" ]] && [[ "$db" != _* ]] ; then
        echo "Dumping database: $db"
        /usr/bin/mysqldump --force --opt --user=$USER --password=$PASSWORD --databases $db > $OUTPUT/`date +%Y%m%d`-$db.sql
        gzip $OUTPUT/`date +%Y%m%d`-$db.sql
    fi
done

# chown deploy:deploy /home/deploy/cadangan/*

# Menyunying cron pengguna deploy
crontab -e
# Menjalankan skrip `dbackdup.sh` setiap harinya pada pukul 00.00
00 00 * * * /bin/bash /home/deploy/dbackup.sh