#!/bin/sh
now="$(date +'%d_%m_%Y_%H_%M_%S')"
dbfilename="project_db_backup_$now".gz
filesfilename="backup_$now".gz
backupfolder="/backup/project/database_backup/"
filesbackupfolder="/backup/project/project_backup/"
fullpathbackupfile="$backupfolder/$dbfilename"
filesfullpathbackupfile="$filesbackupfolder/$filesfilename"
logfile="$backupfolder/"backup_log_"$(date +'%Y_%m')".txt
echo "mysqldump started at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"
mysqldump --user=project_db_user --password=db_user_password --default-character-set=utf8 --single-transaction project_db | gzip > "$fullpathbackupfile"
echo "mysqldump finished at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"
chown user "$fullpathbackupfile"
chown user "$logfile"
echo "file permission changed" >> "$logfile"
#find "$backupfolder" -name db_backup_* -mtime +8 -exec rm {} \;
echo "old files deleted" >> "$logfile"
echo "operation finished at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"
echo "backup files"
cp /home/user/project /backup/user/project_backup/ -rf
tar -zcf "$filesfullpathbackupfile" /backup/user/project_backup/project
echo "*****************" >> "$logfile"
exit 0