让人纠结的phpMyAdmin,大文件上传限制的问题


最近,转移magento的sql文件,但是发现phpMyAdmin默认只有2M。
查阅了下help 文档,记录如下:
1.16 I cannot upload big dump files (memory, HTTP or timeout problems).

         Starting with version 2.7.0, the import engine has been re–written and these problems should not occur. If possible, upgrade your phpMyAdmin to the latest version to take advantage of the new import features.

         The first things to check (or ask your host provider to check) are the values of upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP. One user also said that post_max_size and memory_limit need to be larger than upload_max_filesize.

There exist several workarounds if your upload is too big or your hosting provider is unwilling to change the settings:
•Look at the $cfg['UploadDir'] feature. This allows one to upload a file to the server via
scp, ftp, or your favorite file transfer method. PhpMyAdmin is then able to import the files from the temporary directory. More information is available in the Configuration section of this document.
•Using a utility (such as BigDump) to split the files before uploading. We cannot support

this or any third party applications, but are aware of users having success with it.
•If you have shell (command line) access, use MySQL to import the files directly. You can

do this by issuing the "source" command from within MySQL: source filename.sql.

提示建议升级下phpMyAdmin的版本到2.7.0以上,或者更改php.ini 文件里面的  

upload_max_filesize,memory_limit,post_max_size等值。
有些网站上提示,还要改max_input_time,max_execution_time这些值,及import.php中的

$memory_limit。最纠结的,是我改完这些好,无济于事。重启后,还是默认的2M。直接被气死。。。。。
最后我试着用Navicat,一下子轻松完事。。。。。

来源:http://www.fjshouyeseo.com

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值