Skip to content

Instantly share code, notes, and snippets.

@renefs

renefs/backup_cron.sh

Created May 26, 2014 10:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save renefs/45c1311f392bd6aa43c1 to your computer and use it in GitHub Desktop.
Save renefs/45c1311f392bd6aa43c1 to your computer and use it in GitHub Desktop.
Download ZIP
Database Backup sent by email and triggered at 4AM using CRON.
Raw
backup_cron.sh
DBNAME="<DB_NAME>"
DBPASS="<PASSWORD>"
DBUSER="<USER>"
EMAIL="<EMAIL>"
mysqldump --opt -u $DBUSER -p$DBPASS $DBNAME > backup.sql
gzip backup.sql
DATE=`date +%Y%m%d` ; mv backup.sql.gz $DBNAME-backupFULL-$DATE.sql.gz
uuencode $DBNAME-backupFULL-$DATE.sql.gz $DBNAME-backupFULL-$DATE.sql.gz | mail -s "<SUBJECT>" $EMAIL
rm $DBNAME-backupFULL-$DATE.sql.gz
Raw
crontab
0 4 * * * ~/<PATH_TO>/backup_cron.sh
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment