RPeraltaJr
5/10/2019 - 4:37 PM

Importing Big Databases with MAMP & phpMyAdmin on OSX

source: https://timmyomahony.com/blog/MAMP-phpmyadmin-and-big-database-imports-errors-or-timeouts/

notes.md
content_copyfile_download
  • Rendered
  • Source

There are a couple of reasons for this error message:

  1. MAMP’s PHP has a conservative limit to the amount of data you can POST in a request (32Mb).
  2. MAMP’s PHP has a conservative limit on the size of uploads in general (32Mb).
  3. MAMP’s PHP has a conservative memory allowance by default (8Mb)
  4. MAMP’s PHP has a short timeout value for scripts and pages (30 seconds)

The Solution

To fix this issue, you need to update MAMP’s php.ini file to increase the above limits. Beware though - how you do this depends on whether you are using regular MAMP or MAMP Pro:

  1. MAMP — you need to manually edit the php.ini with a text editor
  2. MAMP Pro — you need to edit the php.ini via the in-app “template” editor