#!/bin/sh

now="$(date +'%d_%m_%Y_%H_%M_%S')"
filename="db_backup_$now".gz
backupfolder="/var/data/db_backups"
fullpathbackupfile="$backupfolder/$filename"
logfile="$backupfolder/logs/"backup_log_"$(date +'%Y_%m')".txt

echo "mysqldump started at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"

(/usr/local/mysql/bin/mysqldump --user=db_usr --password=db_pwd --ignore-table=db.logs \
--default-character-set=utf8 db; \
/usr/local/mysql/bin/mysqldump --user=db_usr --password=db_pwd --no-data --default-character-set=utf8 \
db logs) \
| gzip > "$fullpathbackupfile"

echo "mysqldump finished at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"
chown backup "$fullpathbackupfile"
chgrp backup "$fullpathbackupfile"
chown backup "$logfile"
echo "file permission changed" >> "$logfile"
find "$backupfolder" -name db_backup_* -mtime +90 -exec rm {} \;
echo "old files deleted" >> "$logfile"
echo "operation finished at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"
echo "*****************" >> "$logfile"
exit 0