Mysql Backup Bash Script

 #!/bin/bash

$backup_path='/backup/db_backup/'

date=`date +%m-%d-%Y`

mysql -uroot -p'******' -e "show databases" -ss > /tmp/mysql-database-list

# Remove unwanted database from above list

cat  /tmp/mysql-database-list | grep -v -w information_schema > /tmp/mysql-database-final-list

for i in `cat /tmp/mysql-database-final-list`

do

mysqldump -uroot -p'******'  $i > $backup_path/$i.sql-$date

gzip  $backup_path/$i.sql-$date

done

---------------------------------------

This script create backup of all databases that are available on mysql server.