Servidor Cart - script reciclaSQL.sh
#!/bin/bash
LOG=/cygdrive/c/Users/Administrador/Scripts/LogSQL/limpeza-sql.txt
echo "Limpeza 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 5 dias" >> $LOG
echo " " >> $LOG
sshpass -p lupa*2010! ssh backup@192.168.0.30 'find /shares/backup/srv-cart-ip245/MySQL/ -type f -mtime +5 -exec rm -vf {} \;' >> $LOG
date +%d-%m-%Y-%H:%M:%S >> $LOG
echo " " >> $LOG
sshpass -p lupa*2010! ssh backup@192.168.0.30 'df -h' >> $LOG
echo "Finalizado transferencia">> $LOG
cat /cygdrive/c/Users/Administrador/Scripts/LogSQL/limpeza-sql* | /cygdrive/c/Users/Administrador/Scripts/sendemail/sendEmail.exe -f log@lupainformatica.com.br -t backup@lupainformatica.com.br -u "Cartorio Barra Velha - reciclagem SQL(diario)" -o tls=auto -s webmail.lupainformatica.com.br:587 -xu log@lupainformatica.com.br -xp lupa*2010!