Migrate mongodb to mysql? [closed]

Question

as google isn't really helpful here:

what's the best way of migrating a mongodb database to a mysql database? any best practise examples?

thanks!

Answer 1

After you have completed scarpacci's exercise and have an idea of the mappings, I would then look at mongoexport - you should be careful about type fidelity though and then you will have to import the CSV/TSV into MySQL in a sane manner also.

The other option, especially if you run into typing issues, is to simply pull all of your data out programmatically using your language and driver of choice and insert it directly into MySQL, again using your favorite driver - this gives the most control, but is also the most work.