Guest User

Untitled

a guest
Jul 31st, 2018
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. #!/bin/sh
  2.  
  3. DBUSER=ooo
  4. DBPASS=xxx
  5. DBNAME=db
  6.  
  7. DAYS=7
  8. DEST=/path/your/folder
  9. DATE=`date +%Y%m%d`
  10.  
  11. mkdir -p $DEST
  12.  
  13. echo "Remove old over $DAYS SQL files"
  14. find $DEST -name '*.sql' -mtime "+$DAYS" -exec rm {} \;
  15.  
  16. echo "Backup Databases to SQL file"
  17. mysqldump -u$DBUSER -p$DBPASS $DBNAME > $DEST/$DBNAME-$DATE.sql
Add Comment
Please, Sign In to add comment