mysql_dump.sh

#!/bin/bash

host="192.168.0.53"
user="educacionit"

file=$(date +%Y-%m-%d-%s)_gestioncrm.sql

storage="$HOSTNAME/mysql_dumps"

database="gestioncrm"

# crear directorio destino


ssh ${user}@${host} "mkdir -p $storage"



# Volcado de base de datos

mysqldump $database > /var/backups/$file


gzip /var/backups/$file


# firamdo de bases de datos


gpg --detach-sign --armor \
        --output /var/backups/${file}.gz.sig \
        /var/backups/$file.gz



scp /var/backups/${file}.gz ${user}@${host}:~/$storage
scp /var/backups/${file}.gz.sig ${user}@${host}:~/$storage