Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- DBNAME=<database>
- DBUSER=<dbuser>
- DBPASS=<good-strong-password?>
- DBHOST=localhost
- DESTDIR=/path/to/backup/dir
- NAME=<site-name>
- RETENTION=2
- let MMIN=($RETENTION*60*24)-30
- DATE=`date +%Y-%m-%d-%H-%M`
- if [ ! -d $DESTDIR ]
- then
- /bin/mkdir -p $DESTDIR
- fi
- /usr/bin/find $DESTDIR -type f -name '*.sql.gz' -mmin +$MMIN | xargs /bin/rm -rf
- /usr/bin/mysqldump -h $DBHOST -u$DBUSER -p$DBPASS $DBNAME | gzip - > $DESTDIR/$NAME-$DATE.sql.gz
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement