MySQL backup script per day directory

mysql.sh

#!/bin/sh
export PATH=${PATH}:/usr/local/bin:/usr/bin

mysqldir="/data/backup/mysql"
date=`date +%Y-%m-%d`
dbdir="/var/lib/mysql"

if [ ! -d "${mysqldir}/${date}" ]; then
    mkdir -p ${mysqldir}/${date}
fi

dbs=`ls ${dbdir}`
for db in ${dbs}
do
    if [ -d ${dbdir}/${db} ] && [ "${db}" != "performance_schema" ]; then
        mysqldump -Q -h localhost -u root -pPASSWORD ${db} > ${mysqldir}/${date}/${db}.sql
    fi
done

exit 0