Re: Need a bit of MAMP help please

On Sun, Mar 20, 2016 at 7:54 AM, dealtek@gmail.com <dealtek@gmail.com> wrote: > Hi all, > > I installed a fresh copy of MAMP on EL CAPITAN. > > Then attempted to import some sql files - error said files were too > large... > > So I checked the php.ini files for suggested versions 5.6.10 and 7.0 and > did find "upload_max_filesize" but NOT find = memory_limit and > post_max_size settings in those versions! I did find all the settings in > the previous version 5.6.7 > > > So how can I set php.ini for all 3 settings correctly in v5.6.10 and/or > 7.0? > > or > > How can I get MAMP to use previous version 5.6.7 instead (the MAMP prefs > don't give this choice)? > > --------- from docs..... > > ​​ > 1.16 I cannot upload big dump files (memory, HTTP or timeout problems). > > The first things to check (or ask your host provider to check) are the > values of upload_max_filesize, memory_limit and post_max_size in the > php.ini configuration file. All of these three settings limit the maximum > size of data that can be submitted and handled by PHP. One user also said > that post_max_size and memory_limit need to be larger than > upload_max_filesize. There exist several workarounds if your upload is too > big or your hosting provider is unwilling to change the settings > > > -- > Thanks, > Dave - DealTek > dealtek@gmail.com > [db-16] > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > ​Hi Dave, ​If configurations you are looking for are not present, then you can add them manually and set the value accordingly. And don't forget to restart the Apache. ​Also, for importing sql files you can directly use mysql client from command line(most recommended way), which won't be dependent on PHP. Eg: mysql -u root -p <db-name> < /path/to/db-data.sql​ -- Regards, Jigar Dhulla