MySQL Backup

chmod +x dbbackup
./dbbackup

#!/bin/sh
 
#################################
# MySQL Backup Script                            
#        
# dumps Database [DATENBASE]  
# and truncates binary logs    
# to [DUMPDIR]      
# Author: R. Gemander (Libatech)          
# Web: http://www.libatech.biz                 
# License: GPL      
#################################
#Portalname
SOFTWARENAME="testsoftware"
#DB-Username
DATABASEUSER="username"
PASSWORD="password"
#Database
DATABASE="database"
# path to backup
DUMPDIR="/home/user/databasebackups"
# logfile 
LOGFILE="/home/user/logs/database.log"
#Set the actually date for backup file
DATE=`/bin/date '+%Y-%m-%d'`
## mail goes to:
MAILRECEIVER="user@example.com"
## where is binary
MYSQLBIN="/usr/bin"
# Backup Database:
if test -x $MYSQLBIN/mysqldump
 then
    echo $DATE>>$LOGFILE
    echo "---">>$LOGFILE
    echo "Dumping Database $DATABASE ...">>$LOGFILE
    $MYSQLBIN/mysqldump -u $DATABASEUSER --password=$PASSWORD --flush-logs
    --opt $DATABASE > $DUMPDIR/$DATE.sql
    echo "DONE... new sql backup available in $DUMPDIR">>$LOGFILE
    echo -e "\n">>$LOGFILE
    mail -s "$SOFTWARENAME-Databasebackup Logmeldung" $MAILRECEIVER < $LOGFILE
 else
    echo "Backup failed on $DATE!">>$LOGFILE
    mail -s "$SOFTWARENAME-Backup Error-Logmeldung(Database)" $MAILRECEIVER < $LOGFILE
fi
 

chmod +x /home/user/dbbackup

crontab -e

30 00 * * * /home/user/dbbackup