Import Mysql Data to MongoDB (1) Export data bit csv files from mysql, such: java code SELECT * FROM APP_CALL_LOG_1362959187037 WHERE CREATE_TIME <'2017-03-07 14:45:04 'into outfile'/tmp/all_call_log_012.csv 'fields terminated by', 'Lines terminated by '\ n '; (2) import the csv file to mongodb, for example, the Java code bin/container import -- host 114.112.94.104 -- port 27017-d lb_v1_log-c APP_CALL_LOG -- type csv -- ignoreBlanks-f ID, IP, URI, URL, D_CODE, D_TYPE, UID, APP_FROM, CREATE _ TIME, USER_AGENT, REMARK-file/usr/local/all_call_log_012.csv (3), for example: java code pmy_log_rs: PRIMARY> db. APP_CALL_LOG.update ({UID: "\ N" },{$ set: {'uid': null }}, false, true); pmy_log_rs: PRIMARY> db. APP_CALL_LOG.update ({IP: "\ N" },{$ set: {'IP': null }}, false, true); pmy_log_rs: PRIMARY> db. APP_CALL_LOG.update ({D_TYPE: "\ N" },{$ set: {'d _ TYPE ': null }}, false, true); pmy_log_rs: PRIMARY> db. APP_CALL_LOG.update ({D_CODE: "\ N" },{$ set: {'d _ Code': null }}, false, true); pmy_log_rs: PRIMARY> db. APP_CALL_LOG.update ({CREATE_TIME: "\ N" },{$ set: {'create _ time': null }}, false, true); pmy_log_rs: PRIMARY> db. APP_CALL_LOG.update ({APP_FROM: "\ N" },{$ set: {'app _ from': null }}, false, true); pmy_log_rs: PRIMARY> db. APP_CALL_LOG.update ({URI: "\ N" },{$ set: {'uri ': null }}, false, true); pmy_log_rs: PRIMARY> db. APP_CALL_LOG.update ({URL: "\ N" },{$ set: {'url': null }}, false, true); pmy_log_rs: PRIMARY> db. APP_CALL_LOG.update ({USER_AGENT: "\ N" },{$ set: {'user _ agent': null }}, false, true); pmy_log_rs: PRIMARY> db. APP_CALL_LOG.update ({REMARK: "\ N" },{$ set: {'remark': null }}, false, true); (4) Field Type correction, such: java code db. APP_CALL_LOG.find ({}). forEach (function (x) {x. d_CODE = "" + x. d_CODE; db. APP_CALL_LOG.save (x );});