dump.sh

#!/bin/bash

credentials=''
database=''

TABLES=`mysql $credentials -B -N -e "select TABLE_NAME from information_schema.TABLES where TABLE_SCHEMA='$database'"`

for table in $TABLES; do
    echo -n "dumping $database.$table... "
    if [[ $table == cache* ]]; then
      option="--no-data"
    else
      option=""
    fi
    mysqldump $credentials $option $database $table | gzip > $database.$table.sql.gz
    echo "done"
done