#!/bin/sh
now="$(date +'%d_%m_%Y_%H_%M_%S')"
filename="dbbak_$now".gz
folder="/path/to/bak"
fullpath="$folder/$filename"
log="$folder/"backup_log_"$(date +'%Y_%m')".txt
echo "mysqldump started at $(date +'%d-%m-%Y %H:%M:%S')" >> "$log"
mysqldump --user=mydbuser --password=mypass --default-character-set=utf8 mydatabase | gzip > "$fullpath"
echo "mysqldump finished at $(date +'%d-%m-%Y %H:%M:%S')" >> "$log"
echo "*****************" >> "$log"
exit 0