MySQLdump all database in separate files

mysqldump-all-databases.sh

#!/bin/bash 
DBUSER=root 
DBPASS=deinrootpasswort 
DUMPDIR=./DatabaseDumps 

DUMPDATE=$(date '+%Y-%m-%d') 

if [ ! -d $DUMPDIR ] ; then 
mkdir $DUMPDIR 
fi 

for IDX in $(echo "show databases;" |mysql --user=$DBUSER --password=$DBPASS -s) 
do 
mysqldump --user=$DBUSER --password=$DBPASS --databases $IDX > $DUMPDIR/${IDX}_${DUMPDATE}.sql 
done