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.
php.ini I have already set the maximum execution time to maximum.
How do I fix this error?
Add this line
$cfg['ExecTimeLimit'] = 6000;
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
Answer Checked By – Candace Johnson (BugsFixing Volunteer)