{"id":3798,"date":"2025-06-09T03:58:16","date_gmt":"2025-06-09T03:58:16","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=3798"},"modified":"2026-07-06T03:27:06","modified_gmt":"2026-07-06T03:27:06","slug":"import-data-into-mysql-from-mongodb-exported-json-file","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/jsontomysql\/import-data-into-mysql-from-mongodb-exported-json-file.html","title":{"rendered":"Import data into MySQL from MongoDB exported JSON"},"content":{"rendered":"

Want to import data into MySQL<\/a> from mongodb exported JSON<\/a> file?<\/p>\n

Try Withdata FileToDB<\/a>, a desktop JSON to MySQL converter for Windows, MacOS, and Linux, Import JSON to MySQL, Easy and Fast.<\/p>\n

Download FileToDB<\/a> \"Download<\/a>
\nWindows 64 bit<\/a>
\nWindows 32 bit<\/a>
\nLinux .deb (For Debian, Ubuntu) 64 bit<\/a>
\nLinux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a>
\nMacOS 64 bit<\/a>
\n<\/span><\/p>\n

Import data into MySQL from MongoDB exported JSON file<\/h2>\n

Choose MySQL and logon.<\/p>\n

\"convert<\/p>\n

Click “Wizard – 1 File To 1 Table” at task dialog.<\/p>\n

\"convert<\/p>\n

Select the “JSON” file type.<\/p>\n

\"Import<\/p>\n

then show the wizard.<\/p>\n

1. Open a MongoDB exported JSON file.<\/h3>\n

\"Convert<\/p>\n

2. Select a table and config fields.<\/h3>\n

\"Load<\/p>\n

3. Preview data.<\/h3>\n

\"Insert<\/p>\n

4. Import MongoDB exported JSON to MySQL.<\/h3>\n

\"Import<\/p>\n

You can schedule and automate this converting task by: <\/p>\n

    \n
  1. Save session and create .bat (Windows) or .sh (Linux\/macOS) file for “JSON to MySQL” conversion.<\/a><\/li>\n
  2. Set scheduled task for “JSON to MySQL” conversion.<\/a><\/li>\n<\/ol>\n
    \n

    More about FileToDB<\/a> – JSON to MySQL converter<\/a><\/p>\n

    \n

    Download FileToDB\"Download<\/a>
    \n    Windows 64 bit<\/a>
    \n    Windows 32 bit<\/a>
    \n    Linux .deb (For Debian, Ubuntu) 64 bit<\/a>
    \n    Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a>
    \n    MacOS 64 bit<\/a>
    \n<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    Want to import data into MySQL from mongodb exported JSON file? Try Withdata FileToDB, a desktop JSON to MySQL converter for Windows, MacOS, and Linux, Import JSON to MySQL, Easy and Fast. Download FileToDB Windows 64 bit Windows 32 bit Linux .deb (For Debian, Ubuntu) 64 bit Linux .rpm (For Red Hat, Fedora, SUSE) 64 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1426],"tags":[13292,1418,1323],"class_list":["post-3798","post","type-post","status-publish","format-standard","hentry","category-jsontomysql","tag-import-mongodb-json","tag-json","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=3798"}],"version-history":[{"count":12,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3798\/revisions"}],"predecessor-version":[{"id":32664,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/3798\/revisions\/32664"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=3798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=3798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=3798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}