Home  >  Article  >  Database  >  Solve the problem of phpmyadmin uploading larger than 2M

Solve the problem of phpmyadmin uploading larger than 2M

藏色散人
藏色散人forward
2020-02-21 14:12:432067browse

Solve the problem of phpmyadmin uploading larger than 2M

phpmyadmin Solve the problem of uploading more than 2M

In Linux system:

First : It is the 2M upload limit for sql files. This is a function that has troubled me for many years.

See clearly, modifying php.ini directly will take effect, but the file must be modified correctly. It is php.ini in the apache directory. On Linux, it is /etc/php5/apache2/php.ini

The first step is to find uplod_max_filesize in the PHP.ini configuration file, and change the default 2M to the size of the file you want to import, such as 15M

The second step is to find the uplod_max_filesize in the PHP.ini configuration file. Find post_max_size, change the default 8M to the size of the file you want to import, such as 15M

The third step, find memory_limit in the PHP.ini configuration file, change the default 128M to the size of the file you want to import , if it is already larger than the imported file size, you can leave it unchanged

Complete, you can import files larger than 2M

If it is a Mac system:

sudo cp /etc/php.ini.default /etc/php.ini  ---  复制一份PHP的配置文件到etc目录

Then restart Apache

sudo apachectl restart

For more programming-related content, please pay attention to the Programming Introduction column on the php Chinese website!

The above is the detailed content of Solve the problem of phpmyadmin uploading larger than 2M. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:segmentfault.com. If there is any infringement, please contact admin@php.cn delete