crontab을 이용한 디비백업

실행 파일을 만든다.

파일명:sql.sh


#!/bin/bash
d=$(/bin/date +”%Y%m%d”)
/usr/local/mysql/bin/mysqldump -uroot -p’패스워드’ 디비명 >/backup-sql/디비백업파일명.sql
cp -Ruf /usr/local/mysql/data/db_young /backup-sql/
tar cvfpz /backup-sql/$d.young_sql.tar.gz /backup-sql/*
mv /backup-sql/$d.young_sql.tar.gz /backup-full/

#!/bin/bash

d=$(/bin/date +”%Y%m%d”)

/usr/local/mysql/bin/mysqldump -uroot -p’패스워드’ 디비명 >/backup-sql/디비백업파일명.sql

cp -Ruf /usr/local/mysql/data/db_young /backup-sql/

tar cvfpz /backup-sql/$d.young_sql.tar.gz /backup-sql/*

mv /backup-sql/$d.young_sql.tar.gz /backup-full/

그리고


crontab -e

3 2 * * * /sql.sh

crontab -e

3 2 * * * /sql.sh