Painfully simple database snapshot shell script

db-backup.sh

#!/bin/bash

cd ~/db-backups

# Configure your database info
DB_NAME=sample_db
DB_USERNAME=sample_user
DB_PASSWORD=sample_pw

# Configure the name of the file
FILENAME=dbrains_wp_

SQL_FILE=$FILENAME`date +%Y%m%d%H%M%S`.sql

# Create a database dump file
mysqldump -u $DB_USERNAME --password=$DB_PASSWORD -h localhost $DB_NAME > $SQL_FILE 2>&1

# Compress the database dump file
gzip $SQL_FILE

# Remove database dump files that are a month old
rm -f $FILENAME`date +%Y%m%d* --date='1 month ago'`.sql.gz

# Create folder ~/db-backups and install the following cron to save a snapshot every 2 hours:
# 10 */2 * * * ~/db-backup.sh