致命错误：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_pa​​cket = 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屋！