mysql database 자동 백업하기 10일간 유지
EDIT | DEL
#!/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을 사용해서 실행해준다.
(0) 
(0)
EDIT | DEL
#!/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을 사용해서 실행해준다.
(0) (0)Trackback
Trackback Address :: http://mostech.zzlzzl.net/trackback/3
