注意，此脚本必须在安装有mysql客户端，并且可访问数据库服务器的机子上执行

#########################################################################

日期时间

yesterday=$(date +%Y-%m-%d -d yesterday)
month=$(date +%Y%m -d yesterday)
today=$(date +%Y-%m-%d -d today)
yseconds=$(date -d “$yesterday 00:00:00” +%s)
tseconds=$(date -d “$today 00:00:00” +%s)

数据库账号密码

db_username=”**“
db_password=”**“
db_online_username=”root”
db_online_password=”***“
db_host=”***“
db_online_host=”***“

######################

同步库数据

######################

echo “DB czonline Sync Start… “date +'%Y-%m-%d %H:%M:%S'

for db in **
do
sql_file=”/data/$db.sql”
echo “$db Export Start…$sql_file “date +'%Y-%m-%d %H:%M:%S'
/usr/bin/mysqldump -h $db_host -u $db_username -p”$db_password” –set-g
tid-purged=OFF $db > $sql_file
echo “$dbImport Start… “date +'%Y-%m-%d %H:%M:%S'
/usr/bin/mysql -h $db_online_host -u $db_username -p”$db_password” $db < $
sql_file
echo “DB $db Sync End… “date +'%Y-%m-%d %H:%M:%S'
done
echo “DB ALL Sync End… “date +'%Y-%m-%d %H:%M:%S'

-n: –no-create-db
-d: –no-data
-t: –no-create-info
-R: –routines Dump stored routines (functions and procedures)（导出存储过程）