简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

冲破phpMyadmin上传文件2M大小限制

WBOY
Release： 2016-06-13 11:42:52
Original
874 people have browsed it

突破phpMyadmin上传文件2M大小限制

使用phpMyadmin导入数据库的时候，因为脚本在上传的时候响应时间过长，导致大于2M的数据偶尔会导入失败。而且大多数默认设置，只能导入2M的数据。

遇到这种情况

我们可以修改PHP.ini以及import.php对应的$memory_limit大小限制。还可以直接导入服务器上任意大小的SQL文件。

这里说一下第二个方法：

首先，打开phpMyAdmin根目录下的config.inc.php文件，然后找到

$cfg['UploadDir']
Copy after login

修改为

$cfg['UploadDir'] = ‘ck-import’
Copy after login

然后通过FTP将数据库上传到ck-import文件夹。

保存代码后，在phpMyadmin的后台操作页面会多出来一个(web server upload directory)。在下拉列表里面选择你需要导入的数据库，就可以导入大文件了：



?

同理在备份数据库的时候也可以直接保存在服务器上，修改 $cfg['SaveDir'] = ‘backup’ 参数即可。

?

Related labels：
cfg import php phpmyadmin
source：php.cn
Previous article：为啥mysql_fetch_array没有执行 Next article：PHP模拟POST aspx页面不成功,该怎么解决
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Unable to establish external connection to MySQL/MariaDB database I'm trying to connect a MariaDB client (DBeaver) to my database from my home computer. The...
From 2024-03-31 23:39:43
0
1
302
Docker Image: Integration of PHP 8.0, Apache and phpMyAdmin I'm creating an image for a php8 project running on apache and using phpMyAdmin, my Docker...
From 2024-03-31 18:19:17
0
1
306
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！