让人纠结的phpMyAdmin,大文件上传限制的问题
来源:互联网 发布:阿里云上传速度慢 编辑:程序博客网 时间:2024/05/17 07:35
最近,转移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
- 让人纠结的phpMyAdmin,大文件上传限制的问题
- 让人纠结的N皇后问题
- phpmyadmin上传文件大小限制的配置方法
- 修改phpmyadmin的最大上传限制
- 解决phpmyadmin上传文件大小的限制
- 让人纠结的俗话
- 让人纠结的抉择
- Struts2文件上传的大小限制问题
- Struts2文件上传的大小限制问题
- Struts2文件上传的大小限制问题
- Struts2文件上传的大小限制问题
- 曾遇到的这个让人纠结的问题
- phpmyadmin导入import文件限制的解决方法
- phpmyadmin导入(import)文件限制的解决办法
- phpmyadmin导入(import)文件限制的解决办法
- windows2000server下大文件上传限制问题
- aix中大文件限制的问题
- 让我很纠结的一个问题
- C++的GUID的生成代码
- 如何在Linux中让I2C驱动支持Sub Address的两种方法
- java applet画一棵树
- 怎么才可以得到分数?
- 百度推出新版团购导航 对团购导航造成冲击
- 让人纠结的phpMyAdmin,大文件上传限制的问题
- SC32442上linux-2.6.32.26内核的ax88180官方驱动2.2.0的移植
- popupmenu
- Oracle中Flashback Query的使用
- Response.Write后页面刷新字体变大
- ARM-Linux触摸屏驱动移植--问题总结
- 修改Android中strings.xml文件
- java 动态代理 结合demo直通车
- C++中extern “C”含义深层探索