致命错误:phpmyadmin中超过30秒的执行时间 [英] Fatal error : execution time of 30 seconds exceeded in phpmyadmin
问题描述
我在phpmyadmin中有一个表,它包含650万条记录,当我试图从phpmyadmin访问该表时,我得到:
致命错误:第1457行中的C:\ xampp-new\phpMyAdmin\libraries\display_tbl.lib.php中超出了30秒的最长执行时间。
我只是想查看记录,我没有做任何导致错误的查询。
这个问题只出现在我的
而在我的 php.ini
我的本地机器不包含在服务器中的记录。
如何修复错误? / div>
添加此行
$ cfg ['ExecTimeLimit'] = 6000;
到 phpmyadmin / config.inc.php
$ b
并更改 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(in my.ini)
I have a table in my phpmyadmin and it contains 6.5 million record and when i tried 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 causing the error.
This problem is only in my server.Also my local machine does not contain as much records in server.
And in my php.ini
I had already setup the maximum execution time to maximum.
How to fix the error?
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)
这篇关于致命错误:phpmyadmin中超过30秒的执行时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!