#!/bin/bash
#
## ------ VARIABLES DE CONFIGURACION ----##
#
HOST=localhost
USER=root
PASS=TU_PASSWORD
BACKUP_DIR=/TU/DIRECTORIO/DE/BACKUP
DIA=`date | cut -d' ' -f1`;
## ----- FIN DE LA CONFIGURACION -------- ##
if [ ! -d $BACKUP_DIR ]; then
mkdir -p $BACKUP_DIR
fi
# Backup de MySQL
MYSQL_DBS=$(mysqlshow -h $HOST -u $USER -p$PASS | awk ' (NR > 2) && (/[a-zA-Z0-9]+[ ]+[|]/) && ( $0 !~ /mysql/) { print $2 }');
for DB in $MYSQL_DBS ; do
echo "* Haciendo un backup de los datos MySQL para $DB@$HOST..."
STR=$BACKUP_DIR"/"$DB"_"$DIA"_copsec.sql"
echo "mysqldump -h $HOST -u $USER -p$PASS $DB > $STR"
mysqldump -h $HOST -u $USER -p$PASS $DB > $STR
done