Issue

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 \phpmyadmin\libraries\config.default.php, like this:

$cfg['ExecTimeLimit'] = 0;

Is there any other solution that works for this issue?

Thank you.

Solution

I think You need to change the execution time limit in config.default.php as following:

$cfg['ExecTimeLimit'] = 3600; // whatever time you want to put as execution time

As the script is running out of time so you should have to increase its execution time in MAMP and restart.

Answered By - Aman Kaur