How to import and export big data files and modify php.ini parameters in phpadmin_PHP tutorial

WBOY
Release: 2016-07-21 15:12:50
Original
1163 people have browsed it

Recently, I encountered the problem of using phpadmin to import when the database is too large. The new version of phpadmin has an import limit of 8M, and the old version may be 2M. What should I do if my database is dozens of megabytes?

First of all, if you have a dedicated server or vps, you can find the php.ini file under Apache to modify the 8M or 2M limit. How to modify it?

Search and modify these three

Copy the code The code is as follows:

upload_max_filesize = 2M
post_max_size = 8M
memory_limit = 128M

After modification, restart the service and go to phpadmin to have a look. It should be fine!

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/326606.htmlTechArticleRecently encountered the problem of using phpadmin to import when the database is too large. The new version of phpadmin import limit is 8M, the old The version may be 2M. What should I do if my database is dozens of megabytes? First...
source:php.cn
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
Popular Tutorials
More>
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!