mysql同步文件,mysql数据文件同步脚本

在线QQ客服：1922638

专业的SQL Server、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