/SQL/Maximum execution time of 360 seconds exceeded

Maximum execution time of 360 seconds exceeded

Fatal error: Maximum execution time of 30 seconds exceeded

// you need to add this line at the bottom of your .htaccess file
Before # END WordPress Like this...

php_value max_execution_time 1000
# END WordPress

Maximum execution time of 360 seconds exceeded

A better solution here is to change the config that controls phpMyAdmin and not the php.ini file.

If you change the php.ini file you effect everything in PHP and should you write that infinite loop that we all do from time to time it will take longer to terminate your infinite loop than is sensible.

Note: If you are using the 64bit WAMPServer the base folder name will be wamp64 instead of wamp so please amend the below folder names accordingly.

So change \wamp\alias\phpmyadmin.conf. By default it will look something like this although your version of phpMyAdmin will probably be different:

Alias /phpmyadmin "c:/wamp/apps/phpmyadmin4.1.14/"

<Directory "c:/wamp/apps/phpmyadmin4.1.14/">
   Options Indexes FollowSymLinks MultiViews
   AllowOverride all
  <IfDefine APACHE24>
    Require local
  </IfDefine>
  <IfDefine !APACHE24>
    Order Deny,Allow
      Deny from all
      Allow from localhost ::1 127.0.0.1
    </IfDefine>
  php_admin_value upload_max_filesize 128M
  php_admin_value post_max_size 128M
  php_admin_value max_execution_time 360
  php_admin_value max_input_time 360
</Directory>
To extend the maximum time limit for importing a database, change the php_admin_value max_execution_time parameter. You may also need to change the other parameters as larger databases tend to come in larger files and take longer to read as well. Example:

  php_admin_value upload_max_filesize 1024M
  php_admin_value post_max_size 1024M
  php_admin_value max_execution_time 1800
  php_admin_value max_input_time 1800

Source: stackoverflow.com

Similar codes

51 votes464 views6 answers
Change column name sql
SQL
0 vote385 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote359 views1 answer
Get cpu details sql
SQL
0 vote373 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote409 views1 answer
Sql set data from a select query to a temp table and insert
SQL
1 vote354 views1 answer
Sql Split string function
SQL
1 vote441 views2 answers
Copy table in sql
SQL
8 votes360 views2 answers
Safe update mode in mysql
SQL
5 votes317 views1 answer
Postgres upsert
SQL
3 votes376 views1 answer
Sql timestamp to date
SQL