#!/bin/sh
# by liyuan
date=`date +%Y-%m-%d`
backup_path='/data/mysqlbak/'
for database in `cat ${backup_path}db.txt`; do
/alidata/server/mysql-5.5.37/bin/mysqldump -uroot -p****** --master-data $database >${backup_path}${database}.sql
done
cd ${backup_path}
tar zcf ${date}.sql.tar.gz *.sql
rm -rf *.sql
# by liyuan
date=`date +%Y-%m-%d`
backup_path='/data/mysqlbak/'
for database in `cat ${backup_path}db.txt`; do
/alidata/server/mysql-5.5.37/bin/mysqldump -uroot -p****** --master-data $database >${backup_path}${database}.sql
done
cd ${backup_path}
tar zcf ${date}.sql.tar.gz *.sql
rm -rf *.sql