!/bin/bash
#Script to Backup MySQL Database mysql
#Author: Itxaso Larrinaga

#MySQL settings
mysql_user=root
mysql_password=pass

#Set Database to Backup
database=&mysql

#Set Backup Directory
backup_dir=/var/backups/backup_mysql

#Set logger
logfile=/tmp/logs/resultado.log

#Check MySQL credentials
echo "Checking MySQL connection..."
mysql -u$mysql_user -p$mysql_password -e exit 2>/dev/null
dbstatus=`echo $?`
if [ $dbstatus -ne 0 ]; then
   echo "MySQL $mysql_user password incorrect"
   exit
else
   echo "MySQL $mysql_user password correct"
   echo "Succes! MySQL database connection established"
fi

#Dump and compress database backup
mysqldump -u$root -p$pass $mysql | gzip > "$backup_dir"bd_$(date +%d-%m-%Y).sql.gz
backup=`echo $?`
if [ "$backup" -ne 0 ]; then
   echo "[MYSQL ERROR]["$(date +%d-%m-%Y/%T)"] An error has occurred during the backup operation"
   echo "An error has occurred during the backup operation"
   exit
else
   echo "[MYSQL INFO]["$(date +%d-%m-%Y/%T)"] MySQL backup completed successfully" >> $logfile
   echo "MySQL backup completed successfully"
fi



#Delete files older than 15 days
find  /tmp/backup_mysql/* -mtime +15 -exec rm {} \;