just a script

mysql_backup.sh

#!/bin/bash

MYSQL_USER="root"
MYSQL_PASSWORD="password"
MYSQL_HOST="127.0.0.1"

mysql -u$MYSQL_USER -h$MYSQL_HOST -p$MYSQL_PASSWORD -e "show databases" |
grep -iv -E "(information_schema|Database)" > /tmp/db.txt

if [[ ! -f /tmp/db.ptr ]]; then
    echo "1" > /tmp/db.ptr
fi

start_line=$(cat /tmp/db.ptr)

line_content=$(sed -n ${start_line}p /tmp/db.txt)

while [[ $line_content != "" ]]; do
    echo "[+] Dumping database: $line_content"
    mysqldump -u$MYSQL_USER -h$MYSQL_HOST -p$MYSQL_PASSWORD $line_content > ${line_content}.sql

    ((start_line++))
    echo $start_line > /tmp/db.ptr
    line_content=$(sed -n ${start_line}p /tmp/db.txt)
done