Advertisement
Guest User

Untitled

a guest
Nov 15th, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. DBUSERNAME="***"
  2. DBPASS="****"
  3. BACKUPDIR="/path/<folder_name>/"
  4. TODAY=`date +"%A"`
  5. #enter database names here
  6. DBs=( database_name )
  7.  
  8. #if backupdirectory doesn't exist, create it
  9. if [ ! -d "$BACKUPDIR" ]; then
  10. mkdir -p "$BACKUPDIR"
  11. fi
  12. for database in "${DBs[@]}"; do
  13. #concate directory path, today's day and dbname with .sql ext
  14. filename=$BACKUPDIR${database}_${TODAY}.sql
  15. #take dump
  16. mysqldump -u$DBUSERNAME -p$DBPASS $database > $filename
  17. #compress it
  18. gzip -f $filename
  19. done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement