mysql数据导入到mongodb

MYQSL:

phpadmin导出，前面加字段

 

MONGODB:

启动:
mkdir -p /home/qygame/data
/usr/local/mongodb/bin/mongod -dbpath=/home/data/

备份：
/usr/local/mongodb/bin/mongodump -h 172.16.10.221 -d mmo

恢复：
/usr/local/mongodb/bin/mongorestore
[root@dns2 ~]# /usr/local/mongodb/bin/mongorestore
connected to: 127.0.0.1
Thu Jan 17 11:21:39 dump/mmo/league_rela.bson
Thu Jan 17 11:21:39      going into namespace [mmo.league_rela]
Thu Jan 17 11:21:39      1 objects found
Thu Jan 17 11:21:39 dump/mmo/social.bson
。。。。。

查看:
[root@dns2 ~]# /usr/local/mongodb/bin/mongo
MongoDB shell version: 1.6.2
connecting to: test
> show dbs
admin
local
mmo

 

db.t_passport.remove()
db.t_passport.find()

 

导入csv
/usr/local/mongodb/bin/mongoimport -d mmo -c t_passport --type csv --headerline --file t_passport.csv

--type文件格式
--headerline第一行不导入
--file文件路径