Problem
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 xamppphpmyadminconfig.inc.php.
$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:
C:\xampp\apache\bin\php.ini
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 https://stackoverflow.com/questions/1263680/maximum-execution-time-in-phpmyadmin