Easy MySQL backups with Bash

mysql-backup.sh

#!/bin/bash

# Database credentials
user="XXXXX"
password="XXXXX"
host="XXXXX"
db_name="XXXXX"

# Other options
backup_path="/location/of/your/backups"
date=$(date +"%Y-%m-%d")
timestamp=$(date +"%H-%M-%S")

# Set default file permissions
umask 177

# Dump database into SQL file
mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date-$timestamp.sql

# Delete files older than 5 days
find $backup_path/* -mtime +5 -exec rm {} \;