WAMPServer phpMyadmin 超过360秒的最大执行时间

2022-01-05 00:00:00 php phpmyadmin wampserver

我刚刚安装了 WampServer.当我访问我的项目页面时它有效，但是当我尝试导航 phpMyAdmin 时出现此错误:

I just installed WampServer. It works when I visit my project page but when I try to navigate phpMyAdmin i get this error:

超过最大执行时间 360 秒

Maximum execution time of 360 seconds exceeded

有什么问题?

推荐答案

这里更好的解决方案是更改控制 phpMyAdmin 的配置而不是 php.ini 文件.

A better solution here is to change the config that controls phpMyAdmin and not the php.ini file.

如果您更改 php.ini 文件，您会影响 PHP 中的所有内容，并且您是否应该编写我们不时执行的无限循环，终止无限循环所需的时间会比合理的时间长.

If you change the php.ini file you effect everything in PHP and should you write that infinite loop that we all do from time to time it will take longer to terminate your infinite loop than is sensible.

注意:如果您使用的是 64 位 WAMPServer，基本文件夹名称将是 wamp64 而不是 wamp，因此请修改以下文件夹名称相应地.

Note: If you are using the 64bit WAMPServer the base folder name will be wamp64 instead of wamp so please amend the below folder names accordingly.

因此更改wampaliasphpmyadmin.conf.默认情况下，它看起来像这样，尽管您的 phpMyAdmin 版本可能会有所不同:

So change wampaliasphpmyadmin.conf. By default it will look something like this although your version of phpMyAdmin will probably be different:

Alias /phpmyadmin "c:/wamp/apps/phpmyadmin4.1.14/"

<Directory "c:/wamp/apps/phpmyadmin4.1.14/">
   Options Indexes FollowSymLinks MultiViews
   AllowOverride all
  <IfDefine APACHE24>
    Require local
  </IfDefine>
  <IfDefine !APACHE24>
    Order Deny,Allow
      Deny from all
      Allow from localhost ::1 127.0.0.1
    </IfDefine>
  php_admin_value upload_max_filesize 128M
  php_admin_value post_max_size 128M
  php_admin_value max_execution_time 360
  php_admin_value max_input_time 360
</Directory>

要延长导入数据库的最大时间限制，请更改php_admin_value max_execution_time 参数.您可能还需要更改其他参数，因为更大的数据库往往包含更大的文件，并且读取时间也更长.示例:

To extend the maximum time limit for importing a database, change the php_admin_value max_execution_time parameter. You may also need to change the other parameters as larger databases tend to come in larger files and take longer to read as well. Example:

  php_admin_value upload_max_filesize 1024M
  php_admin_value post_max_size 1024M
  php_admin_value max_execution_time 1800
  php_admin_value max_input_time 1800

不要忘记在更改此文件后重新启动 Apache.

Don't forget to restart Apache after making changes to this file.

相关文章