#!/bin/bash 
###############Basic parameters########################## 
DAY=`date +%Y%m%d` 
Environment=$(/sbin/ifconfig | grep "inet addr" | head -1 |grep -v "127.0.0.1" | awk '{print $2;}' | awk -F':' '{print $2;}') 
USER="backup" 
PASSWD="123456" 
HostPort="3306" 
MYSQLBASE="/home/mysql/" 
DATADIR="/home/db_backup/${DAY}" 
MYSQL=`/usr/bin/which mysql` 
MYSQLDUMP=`/usr/bin/which mysqldump` 
mkdir -p ${DATADIR} 

Dump(){ 
${MYSQLDUMP} --master-data=2 --single-transaction  --routines --triggers --events -u${USER} -p${PASSWD} -P${HostPort} ${database}  > ${DATADIR}/${Environment}-${database}.sql 
cd ${DATADIR} 
gzip ${Environment}-${database}.sql 
} 

for db in `echo "SELECT schema_name FROM information_schema.schemata where schema_name not in ('information_schema','sys','performance_schema')" | ${MYSQL} -u${USER} -p${PASSWD} --skip-column-names` 
do 
   database=${db} 
   Dump 
done