MySQL export to MongoDB

Question

I am looking to export an existing MySQL database table to seed a MongoDB database.

I would have thought this was a well trodden path, but it appears not to be, as I am coming up blank with a simple MySQLDUMP -> MongoDB JSON converter.

It won't take much effort to code up such a conversion utility.

Iván Rodríguez Torres · Accepted Answer · 2016-07-06 10:43:35Z

7

There are a method that doesn't require you to use any other software than mysql and mongodb utilities. The disadvantage is that you have to go table by table, but in your case you only need to migrate one table, so it won't be painful.

I followed this tutorial. Relevant parts are:

Get a CSV with your data. You can generate one with the following query in mysql.

SELECT [fields] INTO outfile 'user.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' FROM [table]

Finally, import the file using mongoimport. That's all

answered Jul 6, 2016 at 10:43

Iván Rodríguez Torres

4,4493 gold badges33 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrew K · Accepted Answer · 2012-07-26 20:50:31Z

5

If you're using Ruby, you can also try: Mongify

It will read your mysql database, build a translation file and allow you to map the information.

It supports:

Updating internal IDs (to BSON ObjectID)
Updating referencing IDs
Type Casting values
Embedding Tables into other documents
Before filters (to change data manually)
and much much more...

Read more about it at: http://mongify.com/getting_started.html

answered Jul 26, 2012 at 20:50

Andrew K

1,34915 silver badges26 bronze badges

Comments

Amala · Accepted Answer · 2010-08-23 15:47:33Z

4

MongoVue is a new project that contains a MySQL import: MongoVue. I have not used that feature.

answered Aug 23, 2010 at 15:47

Amala

1,7461 gold badge18 silver badges30 bronze badges

3 Comments

dimitarvp Over a year ago

Thing is however, it is not free.

Amala Over a year ago

They do have their MySQL import free, is good for one offs. If you need this regularly, and don't want to write a program. Then Talend also made a data connector and is free.

om-nom-nom Over a year ago

Besides it is not free, they are targeting Windows OS only

cedric · Accepted Answer · 2014-05-30 13:09:08Z

3

If you are Mac user you can use MongoHub which has a built in feature to import (& export) data from MySql databases.

answered May 30, 2014 at 13:09

cedric

2411 silver badge5 bronze badges

Comments

sathis · Accepted Answer · 2012-02-06 13:06:00Z

2

If you are using java you can try this

http://code.google.com/p/sql-to-nosql-importer/

edited Feb 6, 2012 at 13:06

answered Jul 23, 2011 at 6:07

sathis

5471 gold badge4 silver badges21 bronze badges

Comments

FullStack · Accepted Answer · 2015-03-11 08:48:06Z

1

For a powerful conversion utility, check out Tungsten Replicator

I'm still looking int this one called SQLToNoSQLImporter, which is written in Java.

answered Mar 11, 2015 at 8:48

FullStack

6,0605 gold badges48 silver badges79 bronze badges

Comments

Jared Alessandroni · Accepted Answer · 2013-03-27 01:52:55Z

0

I've ut a little something up on GitHub - it's not even 80% there but it's growing for work and it might be something other of you could help me out on!

https://github.com/jaredwa/mysqltomongo

answered Mar 27, 2013 at 1:52

Jared Alessandroni

1773 silver badges5 bronze badges

Collectives™ on Stack Overflow

MySQL export to MongoDB

7 Answers 7

Comments

Comments

3 Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

3 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related