#!/bin/bash AUTH="-u root -ppassword" echo "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA where SCHEMA_NAME NOT IN ('mysql', 'information_schema');" \ | mysql $AUTH --silent --skip-column-names \ | while read DB; do echo "Exporting ${DB} to ${DB}.sql" mysqldump $AUTH $DB > ${DB}.sql done