Advertisement
Guest User

Untitled

a guest
May 28th, 2016
84
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. USER="myuser"
  4. PASSWORD="mypassword"
  5. OUTPUT="/etc/mysql/backup"
  6. ExcludeDatabases="information_schema|performance_schema|mysql"
  7.  
  8. if [ ! -d $OUTPUT ]; then
  9. mkdir -p $OUTPUT
  10. fi
  11.  
  12. chmod 0700 $OUTPUT
  13.  
  14. rm "$OUTPUT/*" > /dev/null 2>&1
  15.  
  16. databases=`mysql -u $USER -p$PASWORD -e "SHOW DATABASES;" | tr -d "|" | grep -v $ExcludeDatabases`
  17.  
  18. for db in $databases; do
  19. echo "Dumping database: $db"
  20. mysqldump --add-drop-database --opt --lock-all-tables -u $USER -p$PASSWORD $db | gzip -9 > "$OUTPUT/$db.sql.gz"
  21. done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement