skip to Main Content

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


  1. 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.

    Login or Signup to reply.
  2. 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 to 3600.

    Save the file. Restart Mamp Pro. Database imported successfully.

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search