How ti importing Big Magento DB in MAMP & phpMyAdmin on OSX
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.
Leave a comment
Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.