Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #! /bin/bash
- RETENTION=14
- BACKUP_DIRECTORY='/var/backups/mysql'
- NICE='/usr/bin/nice -n 20'
- MYSQLDUMP='/usr/bin/mysqldump'
- BZIP='/bin/bzip2'
- RM='/bin/rm'
- PASSWORD=`cat /etc/mysql.passwd` # Make sure it's `chmod go-wrx`!
- CWD=`/bin/pwd`
- UMASK=`umask`
- umask u=r,go-wrx
- cd $BACKUP_DIRECTORY
- SQLDUMP=`date +%Y%m%d`.sql
- $NICE $MYSQLDUMP -u root --password='$PASSWORD' --all-databases > ./$SQLDUMP
- $NICE $BZIP ${SQLDUMP}
- FALLOFF="`date --date="$RETENTION days ago" +%Y%m%d`.sql"
- [ -f $FALLOFF ] && $NICE $RM -f $FALLOFF
- cd $CWD
- umask $UMASK
Add Comment
Please, Sign In to add comment