Home  >  Article  >  Database  >  How to modify the upload file size in phpmyadmin

How to modify the upload file size in phpmyadmin

angryTom
angryTomOriginal
2020-02-04 13:28:292799browse

How to modify the upload file size in phpmyadmin

How does phpmyadmin modify the upload file size?

phpmyadmin default import database file size is 2M, which is completely insufficient for our use , to import a database file exceeding 2M, we need to manually modify the php.ini configuration file!

Modify in the php.ini file:

upload_max_filesize  20m(即允许上传文件大小的最大值,默认为2M,修改值大小自定)

After modification, refresh the phpmyadin import database page and you will find that the import database size limit will be displayed as "(maximum Limit: 8,192 KB)" instead of the manually set 20m.

Yes, if you only change the upload_max_filesize setting, the php.ini configuration will default to the size of post_max_size as the standard for the size limit of the database file imported by phpmyamdin.

So we have to make the following modifications:

post_max_size  30m   (指通过表单POST给PHP的所能接收的最大值,包括表单里的所有值,默认为8M)

Refresh the phpmyadin import database page again and you will find that the maximum limit value will become 20m, even if ## is used #upload_max_filesizeConfiguration options. After modifying the above two values ​​many times, we came to the conclusion:

php.ini will take the smaller value of the two configurations upload_max_filesize and post_max_size as the effective value for the import database file size limit! !

Recommended:

phpMyAdmin usage tutorial

The above is the detailed content of How to modify the upload file size in phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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