Following this tutorial over at mongovue about mapreduce in mongodb. They have you export data from MySQL to MongoDB using their .NET tool. I’m on a Mac so here’s what I did instead.

If you followed the instructions, you have the .txt files (which are CSVs) in your MySQL data directory (weird but ok). Importing CSV is really easy in MongoDB. Just make sure you are in the directory with the .txt files.


mongoimport -d geobytes -c cities --type csv --file cities.txt --headerline
mongoimport -d geobytes -c regions --type csv --file regions.txt --headerline
mongoimport -d geobytes -c dmas --type csv --file dmas.txt --headerline
mongoimport -d geobytes -c countries --type csv --file countries.txt --headerline


Now you can continue with the tutorial.

> db.cities.findOne();
{
"_id" : ObjectId("4fa2a734779f0ea93dd13df6"),
"CityId" : 42231,
"CountryID" : 1,
"RegionID" : 833,
"City" : "Herat",
"Latitude" : 34.333,
"Longitude" : 62.2,
"TimeZone" : "+04:30",
"DmaId" : 0,
"Code" : "HERA"
}