#!/bin/bash

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

# Other options
backup_path="/root/backup/mysql"
date=$(date +"%Y-%m-%d_%H|%M")

# Set default file permissions
umask 177

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

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