#!/bin/bash username="root" password="xxxxxxx" dblist=`mysql -u $username -p$password -e "show databases;" | grep -v Database` for db in $dblist do mysqldump -u $user -p$password $db > $db.sql done