CODEWITHSUNDEEP
mysqlmongodbmigration
sparkle
sparkle

Reputation: 7400

How to import a mysql backup to mongodb?

Import in mongodb from mysql, it's possible?

Upvotes: 2

Views: 11001

Answers (6)

Deepankar Agrawal
Deepankar Agrawal

Reputation: 89

You can use mongify http://mongify.com/ This will reduce the labour all u need to give is database credentials

And its opensource too

Upvotes: 2

Orazio Principe
Orazio Principe

Reputation: 11

simply you can use this class, http://www.phpclasses.org/package/8757-PHP-Import-MySQL-database-into-MongoDB.html#information

Upvotes: 1

Virtimus
Virtimus

Reputation: 21

Try this:

Automated export/import using r2n mappings: https://github.com/virtimus/mysql2mongo

Upvotes: 2

Lynn Langit
Lynn Langit

Reputation: 4060

A really simple, but imperfect (due to structural differences), way to do this is to use MongoVue. The import tool costs $35 (not included in the free version). I have only used this to import data from SQL Server to MongoDB, but I have got good results very quickly this way.

Upvotes: 0

sathis
sathis

Reputation: 547

Yes.You can use my plugin. But for that you have to write data transformation configuration.

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

Upvotes: 4

Petrogad
Petrogad

Reputation: 4423

Expanding on what Flukey said; you need to write a script which will do this for you; there isn't a direct export -> import as MySQL is a relational database, where as MongoDB is a NoSQL database.

For further understanding on NoSQL you can read here: NoSQL

You can do something like export to CSV and import into mongo as described in this article CSV Import however, it's very likely that your schema is going to be different in NoSQL compared to MySQL; so it's really worth designing your schema to fit the data then migrate over.

Upvotes: 3

Related Questions