[LINUX] MYSQL 백업 스크립트
#!/bin/sh
DATE=`date +"%Y%m%d"`
PREV_DATE=`date --date '5 days ago' +"%Y%m%d"`
mysqldump -uusername -p'password' database> /home/xxxx/backup/database/mysql_db_back_${DATE}.sql
chown xxxx.xxxx/home/xxxx/backup/database/mysql_db_back_${DATE}.sql
chmod 755 /home/xxxx/backup/database/mysql_db_back_${DATE}.sql
rm -Rf /home/xxxx/backup/database/mysql_db_back_${PREV_DATE}.sql
댓글