blocks|key|3096711|text|您的更改应该会起作用。但是，使用'xampp‘堆栈的php.ini配置文件可能很少。尝试识别是否存在特定于“apache”的php.ini。一个潜在的位置是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3096712|C:\xampp\apache\bin\php.ini|3096713|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Your change should work. However, there are potentially few php.ini configuration files with the 'xampp' stack. Try to identify whether or not there's an 'apache' specific php.ini. One potential location is:

C:\xampp\apache\bin\php.ini

blocks|key|3096751|text|更改web应用程序的php.ini需要重新启动Apache。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3096752|您应该通过运行执行函数phpinfo()的PHP脚本来验证更改是否已经发生。该函数的输出将告诉您许多PHP参数，包括超时值。|3096753|您还可能更改了php.ini的副本，该副本与Apache使用的文件不同。|3096754|entityMap^0|A|7|0|B|9|0|7|7|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|U|8|@]|D|@]|E|$]]]|K|$]]

Changing <code>php.ini</code> for a web application requires restarting Apache.

You should verify that the change took place by running a PHP script that executes the function <code>phpinfo()</code>. The output of that function will tell you a lot of PHP parameters, including the timeout value.

You might also have changed a copy of <code>php.ini</code> that is not the same file used by Apache.

blocks|key|3096765|text|ini_set('max_execution_time',+0);或创建名为php.ini的文件并输入第一行max_execution_time=0，然后保存它并将文件放在应用程序的根文件夹中。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3096766|就这样。祝好运。|3096767|entityMap^0|0|X|12|7|1I|K|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Q|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|R|8|@]|D|@]|E|$]]]|I|$]]

<code>ini_set('max_execution_time', 0);</code> or create file name called <code>php.ini</code> and enter the first line <code>max_execution_time=0</code> then save it and put the file in your root folder of your application.

That's it. Good luck.

blocks|key|331932|text|也许您正在使用XMAPP作为服务，要正确重启XMAPP，您必须打开XMAPP控制面板，取消选中两个针对Apache和MySQL的"Svc“模块。然后单击exit，现在重启XMAPP就完成了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|331933|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Probabily you are using XMAPP as service, to restart XMAPP properly, you have to open XMAPP control panel un-check both "Svc" mdodules against Apache and MySQL. Then click on exit, now restart XMAPP and you are done.

blocks|key|334660|text|我在执行curl时也遇到了同样的问题。当我在php.ini文件中更改以下内容时，我得到了正确的结果：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|334661|max_execution_time+=+1000+;|code-block|syntax|javascript|334662|而且还|334663|max_input_time+=+1000+;|334664|您的问题可能应该通过进行上述两个更改并重新启动apache服务器来解决。|334665|即使在更改了上面的内容之后，问题仍然存在，如果您认为这是由于使用mysql的某些数据库操作造成的，您也可以尝试更改这一点：|334666|mysql.connect_timeout+=+1000+;+//+this+is+not+neccessary|334667|334668|所有这些都应该在php.ini文件中进行更改，并且应该重新启动apache服务器以查看更改。|blockquote|334669|334670|entityMap^0|M|7|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@$9|12|A|13|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|14|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|15|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|16|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|17|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|18|8|@]|D|@]|E|$]]|$1|S|3|T|5|H|7|19|8|@]|D|@]|E|$I|J]]|$1|U|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]|$1|V|3|W|5|X|7|1B|8|@]|D|@]|E|$]]|$1|Y|3|-4|5|6|7|1C|8|@]|D|@]|E|$]]|$1|Z|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|10|$]]

I faced the same problem while executing a curl.
I got it right when I changed the following in the <code>php.ini</code> file:

<pre><code>max_execution_time = 1000 ;
</code></pre>

and also 

<pre><code>max_input_time = 1000 ;
</code></pre>

Probably your problem should be solved by making above two changes and restarting the apache server.

Even after changing the above the problem persists and if you think it's because of some database operation using mysql you can try changing this also:

<pre><code>mysql.connect_timeout = 1000 ; // this is not neccessary
</code></pre>

<blockquote>
 All this should be changed in php.ini file and apache server should be
 restarted to see the changes.
</blockquote>

blocks|key|331964|text|我也有同样的错误，请转到|type|unstyled|depth|inlineStyleRanges|entityRanges|data|331965|331966|+xampp\phpMyAdmin\libraries\config.default.php|blockquote|331967|331968|331969|查找：$cfg['ExecTimeLimit']+=+600;|offset|length|style|CODE|331970|您可以将'600‘更改为任何更高的值，如'6000’。|331971|最大执行时间(秒)为(0表示无限制)。|331972|这将修复您的错误。|331973|entityMap^0|0|0|0|0|0|3|S|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|X|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|10|8|@$J|11|K|12|L|M]]|9|@]|A|$]]|$1|N|3|O|5|6|7|13|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|14|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|15|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|U|$]]

I have the same error, please go to

<blockquote>
 xampp\phpMyAdmin\libraries\config.default.php
</blockquote>

Look for : <code>$cfg['ExecTimeLimit'] = 600;</code>

You can change '600' to any higher value, like '6000'.

Maximum execution time in seconds is (0 for no limit). 

This will fix your error.

blocks|key|334700|text|上的Xampp版本的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|334701|在xampp\phpmyadmin\config.inc.php中添加此行|offset|length|style|BOLD|334702|$cfg['ExecTimeLimit']+=+6000;|code-block|syntax|javascript|334703|并将xampp\php\php.ini更改为|334704|post_max_size+=+750M+
upload_max_filesize+=+750M+++
max_execution_time+=+5000
max_input_time+=+5000
memory_limit+=+1000M|334705|和更改xampp\mysql\bin\my.ini|334706|max_allowed_packet+=+200M|334707|entityMap^0|0|0|11|0|0|0|M|0|0|0|P|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|10|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|11|8|@$D|12|E|13|F|G]]|9|@]|A|$]]|$1|O|3|P|5|J|7|14|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|15|8|@$D|16|E|17|F|G]]|9|@]|A|$]]|$1|S|3|T|5|J|7|18|8|@]|9|@]|A|$K|L]]|$1|U|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|V|$]]

For Xampp version on Windows

Add this line to xampp\phpmyadmin\config.inc.php

<pre><code>$cfg['ExecTimeLimit'] = 6000;
</code></pre>

And Change xampp\php\php.ini to

<pre><code>post_max_size = 750M 
upload_max_filesize = 750M 
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M
</code></pre>

And change xampp\mysql\bin\my.ini

<pre><code>max_allowed_packet = 200M
</code></pre>

blocks|key|3096959|text|转到xampp/php/php.ini|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3096960|找到这一行：|3096961|max_execution_time=30|code-block|syntax|javascript|3096962|并将其值更改为您想要的任何数字。重新启动Apache。|3096963|entityMap^0|2|H|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|U|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|V|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

Go to <code>xampp/php/php.ini</code>

Find this line:

<pre><code>max_execution_time=30
</code></pre>

And change its value to any number you want. Restart Apache.

blocks|key|331985|text|‘'ZERO’，无时间限制。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|331986|C:\Apache24\htdocs\phpmyadmin\libraries\Config.class.php|331987|/**
+*+maximum+execution+time+in+seconds+(0+for+no+limit)
+*
+*+@global+integer+$cfg['ExecTimeLimit']
+*/
$cfg['ExecTimeLimit']+=+0;|code-block|syntax|javascript|331988|331989|您也可以直接从MySQL导入大文件作为查询或PHP查询。|331990|使用这种方法，我在本地服务器上导入500,000行只花了18秒。|331991|(先创建表格)-然后：|331992|LOAD+DATA+LOCAL+INFILE+'Path_To_Your_File.csv'+
INTO+TABLE+Your_Table_Name+
FIELDS+TERMINATED+BY+','+
LINES+TERMINATED+BY+'\n'+|331993|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|V|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|X|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|Y|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Z|8|@]|9|@]|A|$]]|$1|P|3|Q|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|R|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|S|$]]

'ZERO' for unlimited time.

C:\Apache24\htdocs\phpmyadmin\libraries\Config.class.php

<pre><code>/**
 * maximum execution time in seconds (0 for no limit)
 *
 * @global integer $cfg['ExecTimeLimit']
 */
$cfg['ExecTimeLimit'] = 0;
</code></pre>

<hr>

You could also import the large file right from MySQL as query or a PHP query.

500,000 rows just took me 18 seconds to import on local server, using this method.

(create table first) - then:

<pre><code>LOAD DATA LOCAL INFILE 'Path_To_Your_File.csv' 
INTO TABLE Your_Table_Name 
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '\n' 
</code></pre>

blocks|key|3309901|text|对于Wamp用户来说，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3309902|访问：wamp\apps\phpmyadmin3.3.9\libraries|offset|length|style|CODE|3309903|在第536行下，locate+$cfg['ExecTimeLimit']+=+0;|3309904|并将值从0更改为6000。e.g|3309905|$cfg['ExecTimeLimit']+=+0;|code-block|syntax|javascript|3309906|至|3309907|$cfg['ExecTimeLimit']+=+6000;|3309908|重新启动wamp服务器并进行phew。|3309909|它像魔术一样工作！|3309910|entityMap^0|0|3|Z|0|8|X|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@$D|12|E|13|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|14|8|@$D|15|E|16|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|17|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|18|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|6|7|19|8|@]|9|@]|A|$]]|$1|S|3|T|5|N|7|1A|8|@]|9|@]|A|$O|P]]|$1|U|3|V|5|6|7|1B|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1C|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|Z|$]]

Well for Wamp User,

Go to: <code>wamp\apps\phpmyadmin3.3.9\libraries</code>

Under line 536, <code>locate $cfg['ExecTimeLimit'] = 0;</code>

and change the value from 0 to 6000. e.g

<pre><code>$cfg['ExecTimeLimit'] = 0;
</code></pre>

To

<pre><code>$cfg['ExecTimeLimit'] = 6000;
</code></pre>

Restart wamp server and phew.

It works like magic !

blocks|key|333535|text|在php.ini中，您也必须选中mysql.connect_timeout。负责关闭套接字并返回致命的。因此，例如，将其更改为：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|333536|mysql.connect_timeout+=+3600|code-block|syntax|javascript|333537|该时间将始终以秒为单位计算，因此在我的示例中，您有1小时。|333538|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

In php.ini you must check mysql.connect_timeout either. 
That's responsible for socket closing and returning the Fatal.
So, for example, change it to:

<pre><code>mysql.connect_timeout = 3600
</code></pre>

That time will be always counted in seconds, so in my example you have 1 hour.

blocks|key|3097044|text|我在WAMP上工作的是修改文件：\Wamp64\alias\phpmyadmin.conf，行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3097045|+php_admin_value+max_execution_time+600
+php_admin_value+max_input_time+600|code-block|syntax|javascript|3097046|我不需要更改库文件。|3097047|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

What worked for me on WAMP was modifying file:
\Wamp64\alias\phpmyadmin.conf, lines:

<pre><code> php_admin_value max_execution_time 600
 php_admin_value max_input_time 600
</code></pre>

I did not have to change the library file.

When I try to execute (some) queries in phpMyadmin I get this error

<blockquote>
 Fatal error: Maximum execution time of 60 seconds exceeded in
 C:\xampp\phpmyadmin\libraries\dbi\mysql.dbi.lib.php on line 140
</blockquote>

because I have a very large table (over 9 millions records)

I have edited the file C:\xampp\php\php.ini 

and changed the value of "max execution time" from 60 to 1000 then restarts the PHP and still have the same error.

Any solution?

Maximum execution time in phpMyadmin

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

当我尝试在phpMyadmin中执行(一些)查询时，我得到这个错误致命错误:第140行的C:\xampp\phpmyadmin\libraries\dbi\mysql.dbi.lib.php中超过了60秒的最大执行时间因为我有一个非常大的表(超过900万条记录)我已经编辑了文件C:\xampp\php\php.ini并...

问最大执行时间(以phpMyadmin为单位
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问最大执行时间(以phpMyadmin为单位EN