Automate MySQL Backups to S3 with a Pro-Grade Script (And Never Lose Data Again) (opens in new tab)

This shell script (mysql_backup.sh) automates MySQL database backups, keeps a rotating set of backups (newest 7 days intended), compresses them, uploads them to Amazon S3, and sends a notification email.#!/bin/sh # mysql_backup.sh: Backup MySQL databases and keep rotating backups. # ------------------------------- # Configuration # ------------------------------- DB_PREFIX=”BK” # MySQL binaries MYSQLPATH=”/usr/local/mysql” MYSQL=”$MYSQLPATH/bin/mysql --defaults-extra-file=$DB_HOST” MYSQLDUMP=...