서버인프라/데이터베이스
mysqldump backup script
techwold ted
2022. 10. 6. 15:47
Mysql Dump backup Scrip 를 공유 하고자 한다.
간단하게 만들었고, crontap에 넣어서 사용하면 될 것이다.
#!/usr/bin/bash
start=$1
create_directory=`mkdir /backup`
backup_dir="/backup"
db_id="root"
db_pw=""
cnf_dir="/etc/mysql/mariadb.cnf"
date_now=$(date +%Y%m%d)
date_ago=$(date -d "15 day ago" +"%Y%m%d")
function database_backup() {
cd ${backup_dir}
mysqldump -u root EDU > EDU_${date_now}.sql
sleep 3
zip EDU_${date_now}.zip EDU_${date_now}.sql
sleep 3
rm -rf EDU_${date_now}.sql
echo "EDU_${date_now}.sql Delete Compleate"
}
function delete() {
cd ${backup_dir}
rm -rf EDU_${date_ago}.zip
}
$start
Crontap 설정
55 23 * * * root /root/database_backup.sh database_backup
0 1 * * * root /root/database_backup.sh delete