{"id":1002,"date":"2011-09-14T04:12:46","date_gmt":"2011-09-14T11:12:46","guid":{"rendered":"http:\/\/truelogic.org\/wordpress\/?p=1002"},"modified":"2011-09-14T04:12:46","modified_gmt":"2011-09-14T11:12:46","slug":"import-large-data-file-into-mysql","status":"publish","type":"post","link":"https:\/\/truelogic.org\/wordpress\/2011\/09\/14\/import-large-data-file-into-mysql\/","title":{"rendered":"Import Large data file into MySQL"},"content":{"rendered":"<p><strong>How to import a large sql file into mysql<\/strong> when phpmyadmin has hit it\u2019s 5 or so megabyte limit?<\/p>\n<p>This is a common problem\u00a0 so I will place this up here to make it easier to find.<\/p>\n<ul>\n<li>Create the destination database in MySQL<\/li>\n<li>Put the .sql file into a convenient location (the MySQL \/bin directory would be perfect w\/XAMPP)<\/li>\n<li>login to MySQl<\/li>\n<li>SOURCE sqlfilename (if you put it outside mysql bin, you probably need the full path<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>How to import a large sql file into mysql when phpmyadmin has hit it\u2019s 5 or so megabyte limit? This is a common problem\u00a0 so <a class=\"mh-excerpt-more\" href=\"https:\/\/truelogic.org\/wordpress\/2011\/09\/14\/import-large-data-file-into-mysql\/\" title=\"Import Large data file into MySQL\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[36,76,87,147,164,186,205,213,221,242],"class_list":["post-1002","post","type-post","status-publish","format-standard","hentry","category-apachephp","tag-amit","tag-command","tag-data","tag-import","tag-large","tag-mysql","tag-phpmyadmin","tag-prompt","tag-richa","tag-sql"],"_links":{"self":[{"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/posts\/1002","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/comments?post=1002"}],"version-history":[{"count":0,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/posts\/1002\/revisions"}],"wp:attachment":[{"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/media?parent=1002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/categories?post=1002"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/tags?post=1002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}