MySQL数据库表跨域复制同步
##本地数据库导入SQL#!/bin/bashv_db_ip=127.0.0.1v_db_port=3306v_db_user=adminv_db_pwd=123456dir_root=/alidata/projects/tomcat-ins/plan_backend_server_60003/scriptsscript_sql=$dir_root/sql_load_i...
##本地数据库导入SQL
#!/bin/bash
v_db_ip=127.0.0.1
v_db_port=3306
v_db_user=admin
v_db_pwd=123456
dir_root=/alidata/projects/tomcat-ins/plan_backend_server_60003/scripts
script_sql=$dir_root/sql_load_import.sql
fImport(){
echo "exec script_db_import.sh..."
/alidata/server/mysql/bin/mysql \
-P$v_db_port \
-u$v_db_user \
-p$v_db_pwd \
"plan_backend_server" < $script_sql
}
fImport
~
##远程数据库生成SQL文件
v_currday=$1
v_db_ip=127.0.0.1
v_db_port=3306
v_db_user=admin
v_db_pwd=123456
dir_root=/alidata/projects/tomcat-ins/plan_backend_server_60003/scripts
script_sql=$dir_root/sql_load_import.sql
fExportAppSignIn(){
echo "-- export table app_sign_in"
echo "-- export table app_sign_in " >> $script_sql
echo "DELETE FROM \`plan_backend_server\`.\`app_sign_in\` WHERE DATE_FORMAT(\`createTime\`, '%Y%m%d')='"$v_currday"';" >> $script_sql
/alidata/server/mysql/bin/mysqldump "plan_admin" "app_sign_in" \
--host=$v_db_ip \
--port=$v_db_port \
--user=$v_db_user \
--password=$v_db_pwd \
--no-create-db \
--no-create-info \
--default-character-set=utf8 \
--set-gtid-purged=off \
--where="DATE_FORMAT(\`createTime\`, '%Y%m%d')='"$v_currday"'" >> $script_sql
echo "" >> $script_sql
echo "" >> $script_sql
}
fExportAppSignIn
##main方法
#!/bin/bash
echo '1' >> /alidata/projects/tomcat-ins/plan_backend_server_60003/scripts/test.log
v_yesterday=`date -d yesterday +"%Y%m%d"`
echo $v_yesterday
cd /alidata/projects/tomcat-ins/plan_backend_server_60003/scripts
dir_root=/alidata/projects/tomcat-ins/plan_backend_server_60003/scripts
script_sql=$dir_root/sql_load_import.sql
echo "" > $script_sql
./script_db_export_wx.sh $v_yesterday
./script_db_export.sh $v_yesterday
./script_db_pro.sh $v_yesterday
./script_db_import.sh
更多推荐
所有评论(0)