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.

Monday, 26 September 2023 13:33

[solved] Where MAMP PRO MySQL Database Folder

The Updated version of MAMP Pro is saving the databases on a different location. I have installed the MAMP Pro for all users of the machine and can find one here

Open Finder and go to Menu: Go -> Go to Folder and paste them

~/Library/Application Support/appsolute/MAMP PRO/

If the MAMP installation is for specific users, we can find it here

/Macintosh HD/Users/username/Library/Application Support/appsolute/MAMP PRO/db/mysql/