CODEWITHSUNDEEP
phpmysqldatabasephpmyadmin
웃웃웃웃웃
웃웃웃웃웃

Reputation: 11984

Fatal error : execution time of 30 seconds exceeded in phpMyAdmin

I have a MySQL table which contains 6.5 million records. When I try to access that table from phpMyAdmin I get:

Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp-new\phpMyAdmin\libraries\display_tbl.lib.php on line 1457.

I am just trying to view the records and I am not doing any query which might cause the error.

This problem is only in my server. And my local machine does not contain as many records as the server.

In my php.ini I have already set the maximum execution time to maximum.

How do I fix this error?

Upvotes: 18

Views: 134967

Answers (7)

Strenuous
Strenuous

Reputation: 91

Open the xampp folder at your computer where it is installed. For example, it is at C: drive into my PC, and then open the phpMyAdmin and then libraries folder.

"C:\xampp\phpMyAdmin\libraries”

you will find a file there named, "config.default.php". Open the file into any editor or in notepad and find the line "$cfg['ExecTimeLimit'] = 300;", change the value to 0. i.e. $cfg['ExecTimeLimit'] = 0; and save the file. After saving the file restart your xampp control panel. Hurrah! Your problem has been solved.

Upvotes: 0

Souad Henane
Souad Henane

Reputation: 351

Go to:

xampp\phpMyAdmin\libraries\config.default.php

Look for : $cfg['ExecTimeLimit'] = 600;

change '600' to '6000'.

Upvotes: 1

Prakash Choudhary
Prakash Choudhary

Reputation: 31

you need to set max_execution_time in php.ini

max_execution_time=6000

HAPPY CODING

Upvotes: 2

بشر ويسر
بشر ويسر

Reputation: 11

This solution has resolved the issue Place the following lines at the top of the script page and before the query that initiates the memory:

ini_set('max_execution_time', 0);
set_time_limit(1800);
ini_set('memory_limit', '-1');

Upvotes: 1

charles muojekwu
charles muojekwu

Reputation: 71

if you are using xammp on the xammp control panel at the apache line click on config and then click to open PHP(php.ini) find and increase max_execution_time=30 to max_execution_time=600.

Upvotes: 7

M_R_K
M_R_K

Reputation: 6350

Add this line

$cfg['ExecTimeLimit'] = 6000;

to phpmyadmin/config.inc.php

And Change php.ini and my.ini

  • post_max_size = 750M
  • upload_max_filesize = 750M
  • max_execution_time = 5000
  • max_input_time = 5000
  • memory_limit = 1000M
  • max_allowed_packet = 200M (in my.ini)

Upvotes: 59

Brock Hensley
Brock Hensley

Reputation: 3645

+1 for making me lookup lakhs. That looks like a PHP timeout to me as the default timeout is 30 seconds. Increase the setting in your php.ini and restart apache and see if the timeout persists.

http://www.php.net/manual/en/info.configuration.php#ini.max-execution-time

Upvotes: 6

Related Questions