sarathonline.com/blog | Trouble viewing this page? Give Feedback .
Try my blog on: Ajax Version
Search

Thursday, December 02, 2010

Import Mysql data (or a CSV file) into MongoDB

You have MySQL database. And want to move either all, or some of the data into MongoDB. There is no direct way to do it, as such, It can be done in two steps. (If you are here because you have a csv file instead (or directly) move on to Step 2.)

Step 1.
Export all of your MySQL data as a CSV file.

select columns INTO OUTFILE '/path/to/csv' 
   FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
   LINES TERMINATED BY '\n' from table [where clause]

Step 2.
Import the CSV into MongoDB.
Assuming you have MongoDB running (on local, defaults) run the following command
mongoimport -d dbname -c collname 
      -type csv -f fields-sep-by-coma 
      --drop /path/to/csv 

if your csv file has a header row add --headerline.

p.s.: for more options on mongoimport look here

More tips on mongodb, coming

© SarathOnline.com 2000