php WAMPServer phpMyadmin 超过360秒的最大执行时间
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/29916516/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
WAMPServer phpMyadmin Maximum execution time of 360 seconds exceeded
提问by Kvasir
I just installed WampServer. It works when I visit my project page but when I try to navigate phpMyAdmin i get this error:
我刚刚安装了 WampServer。当我访问我的项目页面时它有效,但是当我尝试导航 phpMyAdmin 时出现此错误:
Maximum execution time of 360 seconds exceeded
超过 360 秒的最大执行时间
What is the problem?
问题是什么?
回答by RiggsFolly
A better solution here is to change the config that controls phpMyAdmin and not the php.ini
file.
这里更好的解决方案是更改控制 phpMyAdmin 而不是php.ini
文件的配置。
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.
如果您更改php.ini
文件,您会影响 PHP 中的所有内容,并且您是否应该编写我们不时执行的无限循环,终止无限循环所需的时间将比明智的要长。
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.
注意:如果您使用的是 64 位 WAMPServer,则基本文件夹名称将wamp64
代替,wamp
因此请相应地修改以下文件夹名称。
So change \wamp\alias\phpmyadmin.conf
. By default it will look something like this although your version of phpMyAdmin will probably be different:
所以改变\wamp\alias\phpmyadmin.conf
。默认情况下,它看起来像这样,尽管您的 phpMyAdmin 版本可能会有所不同:
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>
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 max_execution_time
参数。您可能还需要更改其他参数,因为更大的数据库往往包含更大的文件,并且读取时间也更长。例子:
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
Don't forget to restart Apacheafter making changes to this file.
更改此文件后,不要忘记重新启动 Apache。
回答by Gaurav Dave
In your php/php.ini change max_execution_time = 360
to 99999
.
在您的 php/php.ini 更改max_execution_time = 360
为99999
.
OR
或者
You can add ini_set('max_execution_time', 600); //600 seconds = 10 minutes
line on top of your php file.
您可以ini_set('max_execution_time', 600); //600 seconds = 10 minutes
在 php 文件的顶部添加一行。
See, if that works.
看看,如果这有效。
回答by FosAvance
What helped me is to edit config.inc.php
in phpmyadmin
folder and changed:
帮助我的是config.inc.php
在phpmyadmin
文件夹中编辑并更改:
$cfg['Servers'][$i]['host'] = 'localhost';
to
到
$cfg['Servers'][$i]['host'] = '127.0.0.1';
Basically change "localhost" to "127.0.0.1", xampp and wampp differently resolve those two.
基本上将“localhost”更改为“127.0.0.1”,xampp 和 wampp 以不同的方式解决这两个问题。