https://timmyomahony.com/blog/MAMP-phpmyadmin-and-big-database-imports-errors-or-timeouts/ When you are using phpMyadmin on MAMP or MAMP Pro out of the box, you might run into trouble trying to import databases. There are a couple of problems: MAMP’s PHP has a conservative limit to amount of data you can POST in a request (32Mb). MAMP’s PHP has a conservative limit on the […]
Changing the “max_allowed_packet” size in MAMP I manually made a copy of this file “/Applications/MAMP/Library/support-files/my-medium.cnf”. I renamed the copy “my.cnf” and placed it here “/Applications/MAMP/Library/my.cnf” Then I opened “my.cnf” and changed this value “max_allowed_packet = 1M” to “max_allowed_packet = 16M”. Then I restarted MAMP.