Guest User

Untitled

a guest
Dec 16th, 2017
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. function dbbackup() {
  2. if [[ "$1" ]]
  3. then
  4. BACKUP_DIR="$1"
  5. MYSQL_USER="[USERNAME]"
  6. MYSQL_PASSWORD="[PASSWORD]"
  7.  
  8. TIMESTAMP=$(date +"%F")
  9. MYSQL=/usr/bin/mysql
  10. MYSQLDUMP=/usr/bin/mysqldump
  11.  
  12. mkdir -p "$BACKUP_DIR/$TIMESTAMP"
  13.  
  14. databases=`$MYSQL --user=$MYSQL_USER -p$MYSQL_PASSWORD -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"`
  15.  
  16. for db in $databases; do
  17. echo "Backing up: $db"
  18. $MYSQLDUMP --force --opt --user=$MYSQL_USER -p$MYSQL_PASSWORD --default-character-set=utf8 --single-transaction --skip-set-charset --databases $db | gzip > "$BACKUP_DIR/$TIMESTAMP/$db.gz"
  19. done
  20.  
  21. echo "Completed backup"
  22. else
  23. echo "Error: missing required parameters."
  24. echo "Usage: "
  25. echo " dbbackup path"
  26. fi
  27. }
Add Comment
Please, Sign In to add comment