-
Notifications
You must be signed in to change notification settings - Fork 0
/
aml-ddl.sh
3 lines (1 loc) · 823 Bytes
/
aml-ddl.sh
1
2
mysqldump --set-gtid-purged=OFF -hrm-bp19v63q682asdrja.mysql.rds.aliyuncs.com -utaipingbi_etl -p'Tpstic123456' -d tpedw edw_cust_pers_info edw_cust_ply_party edw_cust_units_info rpt_fxq_manual_company_ms rpt_fxq_tb_amltp_entity rpt_fxq_tb_amltp_risk rpt_fxq_tb_amltp_score rpt_fxq_tb_company_ms rpt_fxq_tb_ins_bo_ms rpt_fxq_tb_ins_fav_cst_ms rpt_fxq_tb_ins_gpol_ms rpt_fxq_tb_ins_pers_ms rpt_fxq_tb_ins_rchg_ms rpt_fxq_tb_ins_rcla_ms rpt_fxq_tb_ins_renewal_ms rpt_fxq_tb_ins_risk_ms rpt_fxq_tb_ins_risk_new_ms rpt_fxq_tb_ins_rpay_ms rpt_fxq_tb_ins_rpol_ms rpt_fxq_tb_ins_rsur_ms rpt_fxq_tb_ins_rtype_ms rpt_fxq_tb_ins_unit_ms rpt_fxq_tb_lar_report_ms rpt_fxq_tb_sus_report_ms s_rpt_fxq_tb_ins_rcla_ms s_rpt_fxq_tb_ins_rpol_ms x_edw_cust_pers_units_info x_rpt_fxq_tb_ins_rpol_gpol| gzip > tpedw-ddl`date +%Y-%m-%d`.sql.gz