How ti importing Big Magento DB in MAMP & phpMyAdmin on OSXWritten by Alex 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 -
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.
Latest from Alex
- Как повысить свою эффективность в macOS можно с помощью режима «единственного окна»?
- Launch Sublime Text 3 from the command line & simlink to Subl
- How to make current window screenshot in Mac
- Cracking the Cultural interview. How to pass culture-fit test in Google, Amazon, FB.
- How to Stop .DS_Store File Creation on Network Volumes in Mac OS X