#!/bin/bash

#backup de los base de datos
USER="md32bk"
PASSWORD="Zq62_H4"
DATABASE="simonemax"
FINAL_OUTPUT=/var/www/html/cron/MAX/backup/`date +%Y%m%d`_$DATABASE.sql
mysqldump --user=$USER --password=$PASSWORD --single-transaction $DATABASE > $FINAL_OUTPUT
gzip $FINAL_OUTPUT

# eliminar ficheros antiguos de log y backup
TIEMPO_LOG="10"
TIEMPO_BCK="5"
find /var/www/html/cron/MAX/logs/BKP* -mtime +$TIEMPO_LOG -type f -exec rm {} \;
find /var/www/html/cron/MAX/logs/POL* -mtime +$TIEMPO_LOG -type f -exec rm {} \;
find /var/www/html/cron/MAX/logs/SIN* -mtime +$TIEMPO_LOG -type f -exec rm {} \;
find /var/www/html/cron/MAX/logs/TST* -mtime +$TIEMPO_LOG -type f -exec rm {} \;
find /var/www/html/cron/MAX/backup/*.gz -mtime +$TIEMPO_BCK -type f -exec rm {} \;