如何解决phpmyadmin超时? [英] How to solve time out in phpmyadmin?

问题描述

我想通过 phpMyAdmin 导入巨大的(至少 300 mb)sql 脚本.

我试过了:

post_max_size = 750Mupload_max_filesize = 750M最大执行时间 = 300最大输入时间 = 540内存限制 = 1000M

在我的 php.ini 文件中，但我在导入过程中仍然收到超时错误.

解决方案

如果重复上传后仍然出现超时错误，请在

中更改设置

\phpmyadmin\libraries\config.default.php

从 $cfg['ExecTimeLimit'] = 300; 到 $cfg['ExecTimeLimit'] = 0; 并重新启动.现在没有执行时间限制(相信我们说的是本地服务器).

来源:更改 phpmyadmin 中的脚本超时 >

I want import huge (at least 300 mb) sql scripts via phpMyAdmin.

I've tried:

post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 300
max_input_time = 540
memory_limit = 1000M

in my php.ini file, but I'm still getting timeout errors during importing.

解决方案

If even after repeated upload you still get timeout error, pleasechange your settings in

\phpmyadmin\libraries\config.default.php

from $cfg['ExecTimeLimit'] = 300; to $cfg['ExecTimeLimit'] = 0; and restart. Now there is no execution time limit (trust we are talking about local server).

Source : Change Script time out in phpmyadmin

这篇关于如何解决phpmyadmin超时?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！