{"id":7110,"date":"2017-06-14T11:15:15","date_gmt":"2017-06-14T11:15:15","guid":{"rendered":"https:\/\/jsmwebsolutions.com\/blog\/?p=7110"},"modified":"2024-07-09T14:38:31","modified_gmt":"2024-07-09T14:38:31","slug":"importing-large-sql-files","status":"publish","type":"post","link":"https:\/\/jsmwebsolutions.com\/blog\/importing-large-sql-files\/","title":{"rendered":"Importing large .sql files into phpMyAdmin under MAMP"},"content":{"rendered":"
\n
\n
\n

\n\t\t\t\tUgh. I hate it when I’m trying to make modifications to an existing site and I can’t get the database to import because it’s too large. You end up with a lovely warning message like this:\n\t\t\t<\/p>\n

\n\t\t\t\t \n\t\t\t<\/p>\n

\n\t\t\t\tThis happens to me quite often, and I finally found a workaround for this within my local MAMP dev environment.\n\t\t\t<\/p>\n

\n\t\t\t\t1. Open up the config.inc.php file within the phpmyadmin dir with your favorite code editor. In your local MAMP environment, it should be located here:\n\t\t\t<\/p>\n

\n\t\t\t\tHard Drive » Applications » MAMP » bin » config.inc.php<\/code>\n\t\t\t<\/p>\n

\n\t\t\t\t2. Do a search for the phrase $cfg[‘UploadDir’]<\/em> – it’s going to look like this:\n\t\t\t<\/p>\n

\n\t\t\t\t$cfg['UploadDir'] = '';<\/code>\n\t\t\t<\/p>\n

\n\t\t\t\t3. Change it to look like this:\n\t\t\t<\/p>\n

\n\t\t\t\t$cfg['UploadDir'] = 'upload';<\/code>\n\t\t\t<\/p>\n

\n\t\t\t\t4. Then, within that phpmyadmin dir, create a new folder & name it upload.<\/strong>\n\t\t\t<\/p>\n

\n\t\t\t\t5. Take that large .sql file that you’re trying to import, and put it in that new upload<\/strong> folder.\n\t\t\t<\/p>\n

\n\t\t\t\t6. Now, the next time you go to import a database into phpMyAdmin, you’ll see a new dropdown field right below the standard browse area in your “File to Import” section, like this:\n\t\t\t<\/p>\n

\n\t\t\t\t \n\t\t\t<\/p>\n<\/p><\/div>\n

\n\t\t\t \n\t\t<\/p>\n<\/p><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Ugh. I hate it when I’m trying to make modifications to an existing site and I can’t get the database to import because it’s too large. You end up with…<\/p>\n","protected":false},"author":1,"featured_media":7111,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[232],"tags":[288],"class_list":["post-7110","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech","tag-importing-large-sql-files"],"rttpg_featured_image_url":{"full":["https:\/\/jsmwebsolutions.com\/blog\/wp-content\/uploads\/2017\/06\/localhost_localhost_dump_phpMyAdmin_4.0.4_-_2017-06-14_16.43.43.png",951,443,false],"landscape":["https:\/\/jsmwebsolutions.com\/blog\/wp-content\/uploads\/2017\/06\/localhost_localhost_dump_phpMyAdmin_4.0.4_-_2017-06-14_16.43.43.png",951,443,false],"portraits":["https:\/\/jsmwebsolutions.com\/blog\/wp-content\/uploads\/2017\/06\/localhost_localhost_dump_phpMyAdmin_4.0.4_-_2017-06-14_16.43.43.png",951,443,false],"thumbnail":["https:\/\/jsmwebsolutions.com\/blog\/wp-content\/uploads\/2017\/06\/localhost_localhost_dump_phpMyAdmin_4.0.4_-_2017-06-14_16.43.43-150x150.png",150,150,true],"medium":["https:\/\/jsmwebsolutions.com\/blog\/wp-content\/uploads\/2017\/06\/localhost_localhost_dump_phpMyAdmin_4.0.4_-_2017-06-14_16.43.43-300x140.png",300,140,true],"large":["https:\/\/jsmwebsolutions.com\/blog\/wp-content\/uploads\/2017\/06\/localhost_localhost_dump_phpMyAdmin_4.0.4_-_2017-06-14_16.43.43.png",951,443,false],"1536x1536":["https:\/\/jsmwebsolutions.com\/blog\/wp-content\/uploads\/2017\/06\/localhost_localhost_dump_phpMyAdmin_4.0.4_-_2017-06-14_16.43.43.png",951,443,false],"2048x2048":["https:\/\/jsmwebsolutions.com\/blog\/wp-content\/uploads\/2017\/06\/localhost_localhost_dump_phpMyAdmin_4.0.4_-_2017-06-14_16.43.43.png",951,443,false]},"rttpg_author":{"display_name":"Aj","author_link":"https:\/\/jsmwebsolutions.com\/blog\/author\/admin\/"},"rttpg_comment":0,"rttpg_category":"Tech<\/a>","rttpg_excerpt":"Ugh. I hate it when I’m trying to make modifications to an existing site and I can’t get the database to import because it’s too large. You end up with…","_links":{"self":[{"href":"https:\/\/jsmwebsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jsmwebsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jsmwebsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jsmwebsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jsmwebsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=7110"}],"version-history":[{"count":2,"href":"https:\/\/jsmwebsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7110\/revisions"}],"predecessor-version":[{"id":7113,"href":"https:\/\/jsmwebsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/7110\/revisions\/7113"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jsmwebsolutions.com\/blog\/wp-json\/wp\/v2\/media\/7111"}],"wp:attachment":[{"href":"https:\/\/jsmwebsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=7110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jsmwebsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=7110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jsmwebsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=7110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}