backup-all-dbs.sh

#!/bin/bash
export TERM=xterm;
clear;

echo " ";
echo "---------------------------------------------";
echo "      START | "$(date +%m.%d.%Y-%H.%M.%S);
echo "---------------------------------------------";

#create db dump for all databases

export PATH=/Applications/MAMP/Library/bin/:$PATH;

mysqluser=<YOUR MYSQL USER>;
mysqlpass=<YOUR MYSQL PASSWORD>;
basepath=<WHERE TO STORE DUMPS>;

latest=$basepath"_latest/";
date=$basepath"h_"$(date +%Y%m%d_%H%M)"/";


mv $latest $date;
mkdir $latest;


for I in $(mysql -e 'show databases' -s --skip-column-names -p$mysqlpass -u$mysqluser);
do
  if [[ "$I" == *"_schema" ]]; then
    echo "--skipping $I";
  else
    echo "dumping $I...";
    mysqldump -p$mysqlpass -u$mysqluser $I | gzip > "$latest$I.sql.gz";
  fi
done

echo "---------------------------------------------";
echo "      COMPLETE | "$(date +%m.%d.%Y-%H.%M.%S);
echo "---------------------------------------------";