#!/bin/bash

# Database credentials
user="backup-local"
password=""
host="localhost"
db_name="testando"

# Other options
backup_path="/Desktop/_backup/mysql"
date=$(date +"%d-%b-%Y-%H:%M:%S")

umask 177
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 {} \;