crontab 설정 파일

backup.sh

#!bin/sh
datetime=$(date +%Y_%m_%d)
backupPath=
USERNAME=root
PASSWORD=
DATABASE=

/usr/bin/mysqldump -u$USERNAME -p$PASSWORD -t $DATABASE > $backupPath/mysql_backup_$datetime.sql
tar cvzf mysql_backup_$datetime.tar.gz mysql_backup_$datetime.sql
rm -rf *.sql

 

backup-rm.sh