mysql导数据到mongo,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文件路径