phpMyAdmin Import Database size limit modification

phpMyAdmin The default Import database file size is 2M, but the general Web site's database exported files will exceed this limit, to import more than 2M database files need to manually modify the php.ini configuration file!

In the php.ini file, modify:

upload_max_filesize 20m (that is, the maximum allowable upload file size, the default is 2M, modify the value of the size of the custom)

After you modify, and then refresh the Phpmyadin Import Database page, you will see that the import database size limit is displayed as "(Maximum limit: 8,192 KB)" Instead of manually setting the 20m.

Yes, only if you change the Upload_max_filesize setting, the php.ini configuration defaults to post_max_size the size of the configuration as a standard for Phpmyamdin import database file size limits.

So we have to make the following changes:
post_max_size 30m (refers to the maximum value that can be received by the form Post to PHP, including all values in the form, by default, 8M)

Refreshing the Phpmyadin Import Database page again will reveal that the maximum limit value becomes 20m, which means that the upload_max_filesize configuration option is used. After modifying the above 2 values several times, we conclude that:

PHP.ini will take upload_max_filesize and Post_max_size 2 configured smaller value entries as valid values for the Import database file size limit!!

Note: For the above settings to take effect, you must confirm that:
File_uploads on
(whether to allow the switch to upload files over HTTP.) The default is on is on )