mysqldump

#!/bin/bash

#
# BD
#

# MySQL Hostname
DBHOST='localhost'

# MySQL Username
DBUSER='root'

# MySQL Password
DBPASSWD='xxx'

#
# RUTAS
#

# Local Directory for Dump Files
LOCALDIR=/home/www/mysqldump/

# Prefix for offsite .tar file backup
TARPREFIX=backup_mysql_it-delfos.mad.partners.ad

#
# APP
#

cd $LOCALDIR
SUFFIX=`eval date +%y%m%d`

# DBS=`mysql -u$DBUSER -h$DBHOST -e"show databases"`
DBS=`mysql -u$DBUSER -p"$DBPASSWD" -h$DBHOST -e"show databases"`

for DATABASE in $DBS
do
        if [ $DATABASE != "Database" ]; then
                FILENAME=$SUFFIX-$DATABASE.sql.gz
                mysqldump -u$DBUSER -p$DBPASSWD -h$DBHOST $DATABASE | gzip --best > $LOCALDIR$FILENAME
        fi
done

chmod 400 $LOCALDIR*.gz

#tar --remove-files -cf $TARPREFIX-$SUFFIX.tar $SUFFIX-*.gz
tar --remove-files -cf $TARPREFIX.tar $SUFFIX-*.gz

ls -la $LOCALDIR > /root/tmp/$SUFFIX.tmp

LOG_DATE="$(date +%y)$(date +%m)$(date +%d)"
cp $TARPREFIX.tar $TARPREFIX.$LOG_DATE.tar

# notificacion correo
mail -s "backup mysql $SUFFIX $HOSTNAME" root@it-delfos.mad.partners.ad < /root/tmp/$SUFFIX.tmp
rm -f /root/tmp/*.tmp
exit 0