Backup Database Server

membuat file back-db.sh
diletakan di /etc


=====================================
#!/bin/bash
# modify the following to suit your environment
export DB_BACKUP=”/var/back-db”
export DB_USER=”root”
export DB_PASSWD=”"
# title and version
echo “”
echo “mySQL_backup”
echo “———————-”
echo “* Rotating backups…”
#rm -rf $DB_BACKUP/04
#mv $DB_BACKUP/03 $DB_BACKUP/04
#mv $DB_BACKUP/02 $DB_BACKUP/03
#mv $DB_BACKUP/01 $DB_BACKUP/02
#mkdir $DB_BACKUP/01
echo “* Creating new backup…”
mysqldump –user=$DB_USER –password=$DB_PASSWD –all-databases | gzip > $DB_BACKUP/mysql-`date +%Y-%m-%d`.gz
echo “———————-”
echo “Done”
exit 0
======================================================
membuat folder untuk menampung file backup : /var/back-db/
==========================================================
membuat penjadwalan
========================================
vim /usr/local/bin/cron.txt
0 2 * * * perl /etc/back-db.sh
dengan shell command “crontab cron.txt” untuk meload dan mengeset cron.
backup akan dijalankan setiap pagi jam 2am
=================================================================
selanjutnya mengkopy file backup tadi ke server jardiknas
/usr/bin/rsync -avz –delete –exclude=**/stats –exclude=**/error –exclude=**/files/pictures -e “ssh -i /root/rsync/mirror-rsync-key” root@192.168.1.20:/var/back-db/ /home/jarddds/backup-20/gz-database/