Mysql backup script

mysql_backup,sh

#!/bin/bash
host=""
username=""
password=""
database=""
datestamp=$(date +"%m-%d-%Y")
cd "/databackup/backup"
##Start DATABASE BACKUP
rm *.sql
for x in `mysql --skip-column-names -h$host -u$username -p$password $database -e 'show tables;'`; do
##Verbose
echo working on $x.sql backup...
     mysqldump --hex-blob -h$host -u$username -p$password $database $x > "$x.sql"
done

##Verbose
echo Compressing files...
#xz better compression very slow
#error=$((tar cv *.sql | xz > "MySQL_"$datestamp.tar.xz) 2>&1)

#fast compression  double xz size
error=$((tar -czvf "MySQL_"$datestamp.tar.gz *.sql) 2>&1)
#tar cv *.sql | xz --verbose > "MySQL_"$datestamp.tar.xz

if [ $? -eq 0 ]; then
    echo OK
else
    echo "There was an error. $error" | mail -s "Subject: Backup" <email> "Backup Bot<email>"

fi