[FIXED] Fatal error : execution time of 30 seconds exceeded in phpMyAdmin

Issue

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?

Solution

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)

Answered By - M_R_K