php 如何使用 Xampp 服务器在 phpMyAdmin 中增加导入大小限制？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/31266508/
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
How to Increase Import Size Limit in phpMyAdmin using Xampp server?
提问by Rohit Verma
Does anyone know if or how you can increase the import size limit in phpMyAdmin? Currently my server is limited to 2MB.
有谁知道您是否或如何增加 phpMyAdmin 中的导入大小限制？目前我的服务器被限制为 2MB。
Please note that this is not the same as the upload_max_filesize in php.ini. That value is set to 2MB.
请注意，这与 php.ini 中的 upload_max_filesize 不同。该值设置为 2MB。
I need to import a table into one of my DBs and the phpMyAdmin restriction of 50MB or more MB Data on the import is preventing me from doing that.
我需要将一个表导入到我的一个数据库中，而 phpMyAdmin 对导入数据的 50MB 或更多 MB 数据的限制阻止了我这样做。
回答by Ankit Verma
changes into the php.ini file
post_max_size = 800M
upload_max_filesize = 800M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M
now restart for the changes to take effect
回答by Abey Josey
Change these values in php.ini
在php.ini 中更改这些值
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M
Then restart Wamp for the changes to take effect. It will take some time. If you get following error:
然后重新启动 Wamp 以使更改生效。这将需要一些时间。如果您收到以下错误：
Script timeout passed if you want to finish import please resubmit same zip file and import will resume.
如果您想完成导入，脚本超时已过，请重新提交相同的 zip 文件，导入将恢复。
Then update the phpMyAdminconfiguration, at phpMyAdmin\libraries\config.default.php
然后更新phpMyAdmin配置，在phpMyAdmin\libraries\config.default.php
/**
* maximum execution time in seconds (0 for no limit)
*
* @global integer $cfg['ExecTimeLimit']
*/
$cfg['ExecTimeLimit'] = 0;
回答by Komal
Change below lines in php.ini file:
更改 php.ini 文件中的以下几行：
upload_max_filesize = 64M
post_max_size = 64M
max_execution_time = 300
max_input_time = 500000
memory_limit = 256M
回答by Aminul Islam
You can increase the limit from php.ini file. If you are using windows, you will the get php.ini file from C:\xampp\php directory.
您可以从 php.ini 文件增加限制。如果您使用的是 Windows，您将从 C:\xampp\php 目录中获取 php.ini 文件。
Now changes the following lines & set your limit
现在更改以下几行并设置您的限制
post_max_size = 128M
upload_max_filesize = 128M
max_execution_time = 2000
max_input_time = 3000
memory_limit = 256M
回答by rushabhpathak
go to your cpanel and search "ini editor". You'll get "Multiphp INI Editor"
There you select your wordpress directory and put
upload_max_filesize = 256Mpost_max_size = 256Mmemory_limit = 256M
转到您的 cpanel 并搜索“ini 编辑器”。你会得到“Multiphp INI Editor”在那里你选择你的wordpress目录并放入
upload_max_filesize = 256Mpost_max_size = 256Mmemory_limit = 256M
回答by Muhammad Usman
Be sure you are editing php.ini not php-development.ini or php-production.ini, php.ini file type is Configuration setting and when you edit it in editor it show .ini extension. You can find php.ini here: xampp/php/php
确保您正在编辑 php.ini 而不是 php-development.ini 或 php-production.ini，php.ini 文件类型是配置设置，当您在编辑器中编辑它时，它会显示 .ini 扩展名。你可以在这里找到 php.ini：xampp/php/php
Then
然后
upload_max_filesize = 128M
post_max_size = 128M
max_execution_time = 900
max_input_time = 50000000
memory_limit = 256M
![enter image description here]](/static/img/viewimg.png)
回答by Oscar
After changing your php.inivalues, edit your phpmyadmin.conflocated on wamp\alias directory and increase the values of:
更改php.ini值后，编辑位于 wamp\alias 目录中的phpmyadmin.conf并增加以下值：
php_admin_value upload_max_filesize 256M
php_admin_value post_max_size 256M
php_admin_value max_execution_time 600
php_admin_value max_input_time 600
