#!/usr/bin/env zsh

# UIB-290708  MYSQL DATABASE BACKUPS

databases=( mydb1 mydb2 mydb3 )

server="foo@bar:/databases"

for database in "${databases[@]}"; do

  backup="$database_$(date +%Y_%m_%d_%H%M).tgz"

  mysqldump -u root -p "$database" | tar cvzf "$backup" - && rsync -avP "$backup" "$server"

end