MySQL backups

backup.sh

#!/bin/bash
now=$(date +"%Y-%m-%d")
mysqlUser="root"
mysqlPass="xxx"


server="user@server.com"
log="./backup_sql.log"


      
dbs=`mysql -u "$mysqlUser" -p"$mysqlPass" -e 'SHOW DATABASES;' | grep -Ev "(Database|mysql|information_schema|performance_schema|phpmyadmin)"`
      
      
tmpDir=`mktemp -d`
if [ $? != 0 ]; then
        echo "Can't create tmp directory."
        exit
fi
          
remoteDir="/remote/dir/db/"$(date +"%Y/%m")
ssh "$server" "mkdir -p $remoteDir"
          
echo "" > "$log"
while read -r db; do
        file="$tmpDir/$now.$db".sql.gz
        mysqldump --single-transaction -u "$mysqlUser" -p"$mysqlPass" "$db" | gzip > "$file"
                        
        scp "$file" "$server:$remoteDir/" >> "$log"
        rm "$file"
                                                  
done <<< "$dbs"
rmdir "$tmpDir"