Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- DBUSER=ooo
- DBPASS=xxx
- DBNAME=db
- DAYS=7
- DEST=/path/your/folder
- DATE=`date +%Y%m%d`
- mkdir -p $DEST
- echo "Remove old over $DAYS SQL files"
- find $DEST -name '*.sql' -mtime "+$DAYS" -exec rm {} \;
- echo "Backup Databases to SQL file"
- mysqldump -u$DBUSER -p$DBPASS $DBNAME > $DEST/$DBNAME-$DATE.sql
Add Comment
Please, Sign In to add comment