Geek asks and answers

Fatal error: 30 seconds exceeded in phpMyAdmin

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

Fatal error: The maximum runtime of 30 seconds was exceeded in C: \ xampp-new \ phpMyAdmin \ library \ display_tbl.lib.php on line 1457.

I am just trying to look through the records and not making any queries that might cause an error.

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

In mine, php.iniI already set the maximum runtime to maximum.

How can I fix this error?

+7
source share
4 answers

Add this line

$cfg['ExecTimeLimit'] = 6000;

phpmyadmin/config.inc.php

php.ini 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 ( my.ini)
+34

xammp xammp apache, config, , PHP (php.ini), max_execution_time = 30 max_execution_time = 600.

+3

, , , - .

0

More articles:


All Articles