서버인프라/데이터베이스

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