mysqldump all databases on a given host as separate .zip files

gistfile1.sh

#!/usr/bin/env bash
 
destination="/path/to/save/sql"
mysql_host="localhost"
mysql_user="readaccount"
mysql_pass="password"
  
databases=`mysql -h$mysql_host --user=$mysql_user -p$mysql_pass -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema)"`
 
for db in $databases;
do
  echo `$db`;
  mysqldump --verbose --max_allowed_packet=1073741824 --opt --skip-lock-tables -h$mysql_host -u $mysql_user -p$mysql_pass $db | gzip > "$destination/$db.sql.zip"
done