SAVER DB Backup Daily

Saver DB 일일 백업

crontab -e

59 23 * * * /home/ec2-user/dev/backup/saver-backup.sh >> /tmp/saver-backup.log

sudo rm -rf /etc/localtime 
sudo cp /usr/share/zoneinfo/Asia/Seoul /etc/localtime
sudo systemctl restart crond

cd ~/dev/backup/
touch saver-backup.sh
chmod +x saver-backup.sh
vi saver-backup.sh

• saver-backup.sh

#!/bin/bash
YYYYMMDD=`date '+%Y%m%d'`

cd /home/ec2-user/dev/backup
mysqldump -uuser -ppassword --all-databases > saver-$YYYYMMDD.sql

tar cvfz ~/saver-$YYYYMMDD.tgz saver-$YYYYMMDD.sql
rm -f saver-$YYYYMMDD.sql

aws s3 mv ~/saver-$YYYYMMDD.tgz s3://thesaver-dbbackup/saver-$YYYYMMDD.tgz

• IAM S3 Permission Setup

aws configure
AWS Access Key ID [****************KOWX]: 
AWS Secret Access Key [****************ULEJ]: 
Default region name [ap-northeast-2]: 
Default output format [json]: