#!/bin/bash

myuser=root
mypass=password
mycmd="/data/app/bin/mysql -u$myuser -p$mypass"
mydump="/data/app/bin/mysqldump -u$myuser -p$mypass"

#delete expired backup data
/bin/find /data/backup -mtime +90 -type f | xargs rm -rf
#backup mysql database
for database in `$mycmd -e "show databases ;"|grep -Evi "database|information_schema|performance_schema|sys|test"`
do
 $mydump $database --skip-lock-tables --master-data=2 --single-transaction --flush-logs| gzip > /data/backup/${database}_$(date +%F).sql.gz
done