#!/bin/bash
/usr/local/bin/mysqldump -uroot -p암호 mysql > mysql_db_bak_$(date +%Y%m%d).sql
/usr/local/bin/mysqldump -uroot -p암호 agency > agency_db_bak_$(date +%Y%m%d).sql
/usr/local/bin/mysqldump -uroot -p암호 phone > phone_db_bak_$(date +%Y%m%d).sql
/usr/local/bin/mysqldump -uroot -p암호 sekwang > sekwang_db_bak_$(date +%Y%m%d).sql

mv *.sql /home/backup
tar cvfpz /home/backup/telemagic.co.kr_bak_$(date +%Y%m%d).tar.gz /usr/local/www/data
tar cvfpz /home/backup/mostech_bak_$(date +%Y%m%d).tar.gz /home/mostech/htdocs/phone
tar cvfpz /home/backup/sekwang_bak_$(date +%Y%m%d).tar.gz /home/sekwang/htdocs

find /home/backup -ctime +20 -exec rm -f {} ; #+20은 20일동안 보관

하루에 한번 cron을 사용해서 실행해준다.