mysql数据文件同步脚本

从host1-->host2 服务器数据库

首先：

mysql -hhost1 -Pport1 -ugp_rpt -pPo3H3wAPIi3rznbe -N -e "SELECT order_id, request_id, contract_no, user_id, idcard_no, contract_amount, term, down_payment, phase_amount, repayment_method, manager_fee, channel, source, order_type, order_status, order_time, contract_status, contract_time, intra_contract_status, pay_type, pay_status, pay_time, delivery_status, finish_time, order_mark, latitude, longitude, address, ip, comment, create_time, update_time, first_month, monthly, flow_identifier FROM yytrade.t_order;"  > /tmp/1.txt

其次
mysql -hhost2 -Pport2 -ugp_rpt -pPo3H3wAPIi3rznbe

最后

LOAD DATA LOCAL INFILE '/tmp/1.txt' INTO TABLE test.t_order