如何在phpmyadmin中解决超时问题? [英] How to solve time out in phpmyadmin?
问题描述
我想通过phpMyAdmin导入巨大的(至少 300 mb)SQL脚本.
我尝试过:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 300
max_input_time = 540
memory_limit = 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屋!