Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #! /bin/bash
- TIMESTAMP=$(date +"%F_%T")
- DATE=$(date +"%F")
- BACKUP_DIR="/backup/$TIMESTAMP"
- MYSQL_USER="root"
- MYSQL=/usr/bin/mysql
- MYSQL_PASSWORD="102030"
- MYSQLDUMP=/usr/bin/mysqldump
- NOMEDOBANCO="db"
- EMAIL="email@email.com.br"
- echo
- echo
- echo
- echo Hoje é dia $TIMESTAMP
- echo
- echo Criando diretório
- cd /backup/
- echo
- mkdir -p $BACKUP_DIR
- echo
- echo Fazendo backup
- echo
- mysqldump -u$MYSQL_USER -p$MYSQL_PASSWORD $NOMEDOBANCO > $BACKUP_DIR/$NOMEDOBANCO.sql
- echo
- echo Zipando ..................
- echo
- zip -r $DATE.zip $BACKUP_DIR
- echo
- echo Enviando email..........
- mutt -s "backup $TIMESTAMP" $EMAIL < /sh/email.txt -a /backup/$DATE.zip
- echo Enviado.
- echo
- echo apagango arquivos temporarios
- rm -rf /backup/*
- echo
- echo Fim do script
- echo
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement