Advertisement
Guest User

Untitled

a guest
Mar 31st, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. #! /bin/bash
  2.  
  3. TIMESTAMP=$(date +"%F")
  4. BACKUP_DIR="/path/to/dir"
  5. MYSQL_USER="root"
  6. MYSQL=/usr/bin/mysql
  7. MYSQL_PASSWORD="rootpassorsomething"
  8. MYSQLDUMP=/usr/bin/mysqldump
  9. HOST='server.host'
  10.  
  11. mkdir -p "$BACKUP_DIR"
  12.  
  13. databases=`$MYSQL --host $HOST --user=$MYSQL_USER -p$MYSQL_PASSWORD -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"`
  14.  
  15. for db in $databases; do
  16. $MYSQLDUMP --host $HOST --force --opt --user=$MYSQL_USER --password=$MYSQL_PASSWORD --databases $db | gzip > "$BACKUP_DIR/$db.gz"
  17. done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement