Bash MySQL backup for all databases

mysql-backup.sh

#!/bin/bash

USER=root
PASSWORD=root
DATE_NOW="`date '+%Y-%m-%d_%H-%M-%S'`"
DIR=/var/local/backup

DATABASES=`mysql -u$USER -p$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

echo "Databases found: $DATABASES"

for db in $DATABASES; do
  if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != "mysql" ]] && [[ "$db" != _* ]] ; then
    echo "Exporting $db"
    path=$DIR/"$db"_"$DATE_NOW".sql
    mysqldump -u $USER -p$PASSWORD $db > $path --skip-opt --extended-insert --quick --compact --compress
  fi
done