saving this here because I always lose it

mysqlbackupall.sh

#!/bin/sh
echo "MySQL User:";
read MYSQLUSER;
echo "MySQL Pass:";
read MYSQLPASS;
for I in $(mysql -h localhost -u $MYSQLUSER --password=$MYSQLPASS -e 'show databases' -s --skip-column-names);
  do mysqldump -u $MYSQLUSER -h localhost --password=$MYSQLPASS $I | gzip > "$I.sql.gz";
done