Coder Perfect

phpMyadmin’s maximum execution time


I receive this problem when I try to run (certain) queries in phpMyadmin.

due to the fact that I have a fairly large table (over 9 millions records)

I made changes to the file C:xamppphpphp.ini.

and altered the value of “max execution time” from 60 to 1000, then restarted PHP, but the error remained.

Any solution?

Asked by ahmed

Solution #1

I have the same error, please go to

Look for $cfg[‘ExecTimeLimit’] = 600 in the configuration file.

You can replace ‘600’ with any higher number, such as ‘6000.’

Maximum execution time in seconds is (0 for no limit).

This will resolve your issue.

Answered by user1900623

Solution #2

For the Windows version of Xampp

This line should be added to

$cfg['ExecTimeLimit'] = 6000;

Change xamppphpphp.ini to xamppphpphp.ini to xamppphpphp.ini to xampp

post_max_size = 750M 
upload_max_filesize = 750M   
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

And change xampp\mysql\bin\my.ini

max_allowed_packet = 200M

Answered by M_R_K

Solution #3

While performing a curl, I ran into the identical issue. When I adjusted the following in the php.ini file, it worked:

max_execution_time = 1000 ;

and also

max_input_time = 1000 ;

Making the above two modifications and restarting the apache server should most likely solve your problem.

The problem persists even after changing the above, and if you suspect it’s due to a database operation using mysql, you can try altering this as well:

mysql.connect_timeout = 1000 ; // this is not neccessary

Answered by Sony Mathew

Solution #4

Your modification should be successful. With the ‘xampp’ stack, however, there may be a limited number of php.ini configuration files. Determine whether or whether there is a php.ini file specific to ‘apache.’ The following is one possible location:


Answered by Brian

Solution #5

Changing php.ini for a web application requires restarting Apache.

You should verify that the change took place by running a PHP script that executes the function phpinfo(). The output of that function will tell you a lot of PHP parameters, including the timeout value.

It’s also possible that you updated a copy of php.ini that isn’t the same as the one used by Apache.

Answered by Bill Karwin

Post is based on