DB_USER="root"
DB_PASS="xxxxxxxxxxxxxxxx"
DB_HOST="localhost"

#MYSQL="$(which mysql)"
MYSQL="/usr/local/bin/mysql"
#MYSQLDUMP="$(which mysqldump)"
MYSQLDUMP="/usr/local/bin/mysqldump"
#CHOWN="$(which chown)"
CHOWN="/usr/sbin/chown"
#CHMOD="$(which chmod)"
CHMOD="/bin/chmod"
#GZIP="$(which gzip)"
GZIP="/usr/bin/gzip"
#FIND="$(which find)"
FIND="/usr/bin/find"
#LOGGER="/usr/bin/logger"
LOGGER="/bin/echo"

BACKUP_PATH="/home/backup"
BACKUP_PATH_MYSQL="$BACKUP_PATH/mysql"

IGNORE_TABLE1="--ignore-table=intimcityru.ip2metro_full"
IGNORE_TABLE2="--ignore-table=intimcityru.persons_views_ips"

HOST="$(hostname)"
DATE="$(date +"%d-%m-%Y")"

FILE=""
DBS=""
EXCLUDE_DB="test"


[ ! -d $BACKUP_PATH_MYSQL ] && mkdir -p $BACKUP_PATH_MYSQL || :

#$CHOWN root:whell -R $BACKUP_PATH
#$CHMOD 0600 $BACKUP_PATH_MYSQL

DBS="$($MYSQL -u $DB_USER -h $DB_HOST -p$DB_PASS -Bse 'show databases')"
$LOGGER "$(basename $0) mysql: Started at $(date)"
for db in $DBS
do
#    FILE="$BACKUP_PATH_MYSQL/$db.$HOST.$DATE.gz"
    FILE="$BACKUP_PATH_MYSQL/$db.$DATE"
    $LOGGER "$(basename $0) mysql: backup db:$db to file:$FILE $(date)"
    $MYSQLDUMP -u $DB_USER -h $DB_HOST -p$DB_PASS $IGNORE_TABLE1 $IGNORE_TABLE2 $db > $FILE
done
$LOGGER "$(basename $0) mysql: Ended at $(date)"
$LOGGER "$(basename $0) gzip: Started at $(date)"
for db in $DBS
do
        FILE="$BACKUP_PATH_MYSQL/$db.$DATE"
        $LOGGER "$(basename $0) gzip: compression db:$db to file:$FILE.gz $(date)"
        $GZIP -f $FILE
done
$LOGGER "$(basename $0) gzip: Ended at $(date)"

$FIND $BACKUP_PATH_MYSQL -name '*.??-??-????.gz' -mtime +14 -delete