I’m trying to upload this sql file that’s 225MB to phpmyadmin with MAMP.
However, I keep getting this error
Script timeout passed, if you want to finish import, please resubmit the same file and import will resume.
I’ve changed the php.ini file in MAMP like so:
max_execution_time = 6000
max_input_time = 6000
memory_limit = 1000M
post_max_size = 750M
upload_max_filesize = 750M
I’ve also changed the setting in phpmyadminlibrariesconfig.default.php, like this:
$cfg['ExecTimeLimit'] = 0;
Is there any other solution that works for this issue?
Thank you.
2
Answers
I think You need to change the execution time limit in config.default.php as following:
As the script is running out of time so you should have to increase its execution time in MAMP and restart.
I just ran into this problem myself and here is my fix.
I am using Mamp Pro, so I searched for
phpmyadmin
on my mac using Finder search bar.It found a file called
config.inc.php
. The file was living under/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin
I then found the line for
$cfg['ExecTimeLimit']
and changed the value to3600
.Save the file. Restart Mamp Pro. Database imported successfully.