mysqldump

backup_mysql.sh
#!/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_<server>
 
#
# 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"`
# existe versión con SED para eliminar /Database/
 
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