Advertisement
Guest User

Untitled

a guest
Feb 16th, 2016
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. /usr/local/bin/backup_databases
  2. #! /bin/bash
  3.  
  4. TIMESTAMP=$(date +"%FT%T")
  5. BACKUP_DIR="/var/www/db_backup/$TIMESTAMP"
  6. MYSQL_USER="backup"
  7. MYSQL=/usr/bin/mysql
  8. MYSQL_PASSWORD=“******* nasralfranta na trabanta *******”
  9. MYSQLDUMP=/usr/bin/mysqldump
  10.  
  11. mkdir -p "$BACKUP_DIR"
  12.  
  13. databases=`$MYSQL --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 --force --opt --user=$MYSQL_USER -p$MYSQL_PASSWORD --databases $db | gzip > "$BACKUP_DIR/$db.sql.gz"
  17. done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement