如何在phpMyAdmin中增加导入大小限制 [英] How to Increase Import Size Limit in phpMyAdmin

问题描述

有人知道是否可以或如何增加phpMyAdmin中的导入大小限制?目前，我的服务器限制为50MB.

Does anyone know if or how you can increase the import size limit in phpMyAdmin? Currently my server is limited to 50MB.

请注意，这与php.ini中的upload_max_filesize不同.该值设置为2MB.

Please note that this is not the same as the upload_max_filesize in php.ini. That value is set to 2MB.

我需要将一个表导入到我的一个数据库中，并且导入时phpMyAdmin限制为50MB，这使我无法这样做.

I need to import a table into one of my DBs and the phpMyAdmin restriction of 50MB on the import is preventing me from doing that.

谢谢.

修正-随附2个屏幕截图:

Amended -- attached are 2 screen shots:

屏幕快照1-显示php.ini设置的phpinfo(). 屏幕截图2-显示phpMyAdmin导入限制

Screen Shot #1 -- phpinfo() showing the php.ini settings. Screen Shot #2 -- showing the phpMyAdmin import restriction

推荐答案

您还可以增加post_max_size并查看是否有帮助?

Could you also increase post_max_size and see if it helps?

通过HTML表单上载文件使得上载与其他任何表单元素内容一样，这就是为什么也需要增加post_max_size的原因.

Uploading a file through an HTML form makes the upload treated like any other form element content, that's why increasing post_max_size should be required too.

更新:最终解决方案涉及命令行:

Update : the final solution involved the command-line:

要仅导出1张表，您将

mysqldump -u user_name -p your_password your_database_name your_table_name > dump_file.sql

并导入:

mysql -u your_user -p your_database < dump_file.sql 

'删除表your_tabe_name;'也可以将其添加到导入脚本的顶部(如果尚未添加)，以确保在脚本创建并填充表之前将其删除

'drop table your_tabe_name;' can also be added at the top of the import script if it's not already there, to ensure the table gets deleted before the script creates and fill it

这篇关于如何在phpMyAdmin中增加导入大小限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！