mysql 자동 backup

http://foxrain93.blog.me/100192636540

자동 백업 스크립트 만들기

# vi mysqlbackup

---------------------------------------

#!/bin/sh

DATE=`date +"%Y%m%d"`

OLD_DATE=`date --date '5 days ago'+"%Y%m%d"` 

BACKUP_DIR=/mysqlbackup 

/usr/bin/mysqldump -uroot -ppassword dbname > ${BACKUP_DIR}/dbname_${DATE}.sql 

(or dbname -> --all-databases) 

chown root.root ${BACKUP_DIR}/dbname_${DATE}.sql 

chmod 755 ${BACKUP_DIR}/dbname_${DATE}.sql 

rm -Rf ${BACKUP_DIR}/dbname_${OLD_DATE}.sql 

-------------------------------------------------------------- 

# chmod 755 mysqlbackup 

 

매일 3시 1분에 실행

# crontab -e

----------------------------------

1 3 * * * sh /mysqlbackup/mysqlbackup > /dev/null 2>&1

------------------------------------

 

/etc/rc.d/init.d/crond stop

/etc/rc.d/init.d/crond start

[출처] mysql 자동 backup|작성자 진저티