php 增加phpmyadmin中的文件大小限制
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/18395526/
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
Increase the file size limit in phpmyadmin
提问by Ishu
I have a sql file 480,396kb. I could not import the file in my phpmyadminin this memory limit
我有一个 sql 文件480,396kb。我无法phpmyadmin在此内存限制中导入文件
is (Max: 128MiB) only. When I import the sql file it shows the error
128MiB仅是 (Max:) 。当我导入 sql 文件时，它显示错误
You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit.
您可能尝试上传过大的文件。有关此限制的解决方法，请参阅文档。
I changed the memory limit in php.inifile both
我改变了php.ini文件中的内存限制
upload_max_filesizeand post_max_sizealso.
upload_max_filesize和post_max_size也。
回答by Napster
Importing a large file from the command line is simple:
从命令行导入大文件很简单：
#mysql -p... -u... -h... database_name < file.sql
OR
或者
You can use this plugins
你可以使用这个插件
回答by pEte wEntz Mendoza
restart the connection of your apache.
重新启动 apache 的连接。
回答by Sagar Thesia
Try to change max_file_uploads, did you see maxfilesize to upload in phpmyadmin,if you change all in php.ini then it must update,
尝试更改max_file_uploads，您是否在phpmyadmin中看到要上传的maxfilesize，如果您在php.ini中更改了所有内容，则必须更新，
also restart apache
也重启apache
回答by Wim Mostmans
I would suggest using the mysql command line tool for importing a database. This way you don't have the memory limit problem and the import is 100x faster.
我建议使用 mysql 命令行工具来导入数据库。这样您就没有内存限制问题，导入速度提高了 100 倍。
