Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- # Database credentials
- user="USERNAME"
- password="PASSWORD"
- host="HOST"
- db_name="DATABASE"
- # General config
- backup_path="/WHERE/TO/PUT/BACKUP/FILE"
- date=$(date +"%b-%d-%Y")
- # Set default file permissions
- umask 177
- backup_file=$backup_path/$date-$db_name.sql.gz
- # Backup and compress database
- mysqldump -u $user -p$password -h $host $db_name | gzip > $backup_file
- # Notify Brad Williams about the backup file
- if [ -f $backup_file ]; then
- echo "Microsoft Dynamics PROD DB Successfully backed up" | mail -s "DB Backup Successful" -r YOUR@EMAIL.ADDRESS
- else
- echo "Microsoft Dynamics PROD DB backup FAILED" | mail -s "DB Backup FAILED!!!" -r YOUR@EMAIL.ADDRESS
- fi
- # Delete files older than 30 days
- find $backup_path/* -mtime +30 -exec rm {} \;
- ~
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement