#!/bin/bash
 
for i in `mysqlshow | awk '{print $2}' | grep -v Databases |grep -v information_schema` ; do
  mysqldump -uroot --create-options --opt $i | gzip > /var/lib/mysql-backups/daily/$i-nightly.dmp.gz
done