mysql 자동 backup 2

http://foxrain93.blog.me/100192636540

자동 백업 스크립트 만들기

# vi mysqlbackup

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

#!/bin/sh

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

BACKUP_DIR=/mysqlbackup 

FILENAME=mysqlback 

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

# (or dbname -> --all-databases) 

cd ${BACKUP_DIR} 

tar cfpz ${FILENAME}_${DATE}.tar.gz ${FILENAME}_${DATE}.sql 

rm -Rf ${FILENAME}_${DATE}.sql  

chown root.root ${BACKUP_DIR}/${FILENAME}_${DATE}.tar.gz 

chmod 755 ${BACKUP_DIR}/${FILENAME}_${DATE}.tar.gz 

find ${BACKUP_DIR}/ -mtime +5 -exec rm -f {} \; 

cp ${BACKUP_DIR}/${FILENAME}_${DATE}.tar.gz /nfs 

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

# chmod 755 mysqlbackup 

 

매일 3시 1분에 실행

# crontab -e

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

01 03 * * * sh /mysqlbackup/mysqlbackup > /dev/null 2>&1

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

 

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

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

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