How ti importing Big Magento DB in MAMP & phpMyAdmin on OSX

Written by  Thursday, 08 December 2016 10:01

Once you have your version, open Finder, press [Shift][Command][G] and enter /Applications/MAMP/bin/php/php5.5.10/conf/. You will see a php.ini file. Open it in your favourite text editor. You are going to change the values of the following variables:

; Maximum size of POST data that PHP will accept.
post_max_size = 256M

; Maximum allowed size for uploaded files.
upload_max_filesize = 256M

; Maximum execution time of each script, in seconds
max_execution_time = 600     

; Maximum amount of time each script may spend parsing request data
max_input_time = 600    

; Maximum amount of memory a script may consume (8MB)
memory_limit = 512M    

It is important to note that for the variables related to size - post_max_size, upload_max_size and memory_limit - you must change the variable to a size larger than that of the .sql file that you are trying to import. My .sql file was 170mb but if you are importing a larger .sql file you need to set the memory-related variables to an appropriately large value.

Now restart MAMP and you should no longer be experiencing the problems.

288 Read Last modified on Sunday, 22 October 2017

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

Related items

  • Improving conversion rate from existing traffic with Magento extensions

    If you are also a retailor, have your ever thought that you will be the formidable opponent of the giant like Amazon and Walmart or at least you desire to compete with them? If our answer is yes, you should build an actually powerful online selling system. So, the core of your marketing strategy should be conversion rate, not just traffic because traffic is just the visible part of the iceberg. There is one thing which is always true that a company selling well will gain high conversion rate. That is the evident truth.

    A common mistake of many business owners is putting too much efforts on stimulating traffic amount and almost forgetting conversion rate. If traffic is not converted, what does that high traffic amount mean?  After all, rate of conversion or purchasing seems to be the most proper criteria to evaluate whether how well your business works.

  • What makes Magento extensions be one of the best online store development platforms?

    Life has been changing and the way we shopping is now totally different from the past. Nowadays, queuing up outside stores or traveling a long distance to buy something you want from your favorite retailers is just in the past, it’s time for you to forget them. While retail industry is still the billions industry, there is another one has appeared and gone along with the development of retail, that is Ecommerce. It can be said that making the sale online is never a difficult task, especially when you have already had Magento store. From the first time, Magento has been considered as one of the best online store development platforms, business owners love it due to the powerful features provided.

  • [solved] How to add Slider in Magento
    {{block type="ultraslideshow/slideshow" template="infortis/ultraslideshow/slideshow.phtml" slides="dnk_slide_2017_landing1,dnk_slide_2017_landing2,dnk_slide_2017_landing3" timeout="30000"}}
  • [solved] How I can add Contact Form in Magento
    We need put this code in you html-page:
    <!– CONTACT FORM CODE BEGIN–>
    {{block type='core/template' name='contactForm' template='contacts/form.phtml'}}
    <!– CONTACT FORM CODE END–>

  • Magento 2 - best commands
    magento deploy:mode:set production
    
    magento deploy:mode:set developer
    
    magento setup:cache:{enable|disable|clean|flush|status}
    
    magento setup:indexer:{status|show-mode|set-mode|reindex|info}
    
    magento cron:run
    
    magento setup:di:compile
    
    magento setup:static-content:deploy
    
    magento dev:source-theme:deploy