#!/bin/bash
# Database credentials
 user="mysql-username"
 password="mysql-password"
 host="server ip"
 db_name="database name"
# Other options
 backup_path="/path/to/store/backup/files"
 date=$(date +"%d-%b-%Y")
# 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.sql
# Delete files older than 30 days
 find $backup_path/* -mtime +30 -exec rm {} \;