#!/usr/bin/env zsh

# UIB-290708  MYSQL DATABASE BACKUPS

databases=( mydb1 mydb2 mydb3 )

server="foo@bar:/databases"

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

  tarball="$database_$(date +%Y%m%d_%H%M).tgz"

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

end