Dump and backup MySQL database to S3 server

do_space.sh

#!/bin/bash
#
# LRsoft Corp.
# https://lrsoft.co.id
# 
# Author: Zaf
# Date: 10/22/18
# Time: 10:01 AM

# install https://s3tools.org/download first

# config
DB_NAME=db
DB_USER=user
DB_PASS=pass
S3_PATH=path/to/s3/dir/

FILE_NAME=mysql-$(date +%Y%m%d-%H_%M_%S)

echo "dump db..."
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $FILE_NAME.sql

echo "compress..."
tar -czvf $FILE_NAME.tar.gz $FILE_NAME.sql

echo "put to s3..."
s3cmd put $FILE_NAME.tar.gz s3://$S3_PATH

echo "clean up..."
rm -f $FILE_NAME*