本文介绍一下如何修改导入数据库时候的大小限制,笔者在用phpmyadmin导入mysql数据库时,遇到15M的数据库不能导入,mysql数据库最大只能导入2M..
phpmyadmin数据库导入出错:
You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.
可以修改导入数据库文件最大限制吗?可以!
解决这个问题,可以参考phpmyadmin文档;直接点击这个链接,phpmyadmin自动查找到了以下说明:
The first things to check (or ask your host provider to check) are the values ofupload_max_filesize, memory_limit and post_max_sizein 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.
以上文件大致说明的意思就是说,遇到导入过大文件时,首先检查php.ini 配置文件中的以下三个地方,upload_max_filesize, memory_limit 和post_max_size,并且推荐修改的值要稍大于导入的巨大sql数据库文件;依照这个提示,修改了以上三个在php.ini中的值以后,重启了php环境,再次导入时,数据库文件已经被成功的导入了。