#!/bin/bash
# Database credentials
user="root"
password="xxx2015"
host="127.0.0.1"
db_name="historico"
backup_path="/backups/mensual"

date=$(date +"%d-%b-%Y")

#permisos por defecto
umask 177

mysqldump --user=$user --password=$password --routines --host=$host $db_name > $backup_path/$db_name-$date.sql
bzip2 $backup_path/$db_name-$date.sql
chmod 655 $backup_path/$db_name-$date.sql.bz2
rm  $backup_path/$db_name-$date.sql

#borro backups de mas de 35 dias
 find $backup_path/* -mtime +35 -exec rm {} \;