MySQL Backup script for all databases

gistfile1.sh

#!/bin/bash

user=""
password=""
host=""

backup_path="/path/to/your/home/_backup/mysql"
date=$(date +"%d-%b-%Y")

# Get list of databases
databases=$(mysql --user=$user --password=$password -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema)")

# Create folder using date
mkdir $backup_path/$date

# Create dumps for each database
for db in $databases 
do
  mysqldump --user=$user --password=$password --host=$host $db > $backup_path/$date/$db.sql
done