Servidor Cart - script envioSQLdiario.sh
#!/bin/bash
LOG=/cygdrive/c/Users/Administrador/Scripts/LogSQL/backup-sql.txt
echo "Iniciando a copia SQL Cart" > $LOG
date +%d-%m-%Y-%H:%M:%S >> $LOG
echo " " >> $LOG
echo "Reciclagem do espaço" >> $LOG
echo "Removendo arquivos SQL anteriores a 30 dias" >> $LOG
echo " " >> $LOG
#sshpass -p lupa*2010! ssh backup@192.168.0.30 'find /shares/backup/srv-cart-ip245/MySQL/ -type f -mtime 30 -exec rm -v {} \;'
echo "Enviando arquivo SQL" >> $LOG
sshpass -p lupa*2010! rsync -av --stats /cygdrive/f/MySQL/ backup@192.168.0.30:/shares/backup/srv-cart-ip245/MySQL/ >> $LOG
echo " " >> $LOG
sshpass -p lupa*2010! ssh backup@192.168.0.30 'df -h' >> $LOG
date +%d-%m-%Y-%H:%M:%S >> $LOG
echo " " >> $LOG
echo "Finalizado transferencia">> $LOG
cat /cygdrive/c/Users/Administrador/Scripts/LogSQL/backup-sql* | /cygdrive/c/Users/Administrador/Scripts/sendemail/sendEmail.exe -f log@lupainformatica.com.br -t backup@lupainformatica.com.br -u "Cartorio Barra Velha - Envio SQL NAS (diario)" -o tls=auto -s webmail.lupainformatica.com.br:587 -xu log@lupainformatica.com.br -xp lupa*2010!