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