Modify the size limit of the SQL file imported by phpMyAdmin

When using phpMyAdmin to import a mysql database, my MB database cannot be imported, prompting that the mysql database can only be imported at most 2 MB.

An error occurred while importing the phpMyAdmin database:

You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

Can I modify the maximum limit of imported database files?

I searched the internet for solutions from our predecessors. Most of them mentioned modifying php. upload_max_filesize in ini, but after this is modified, this question is still prompted; but when phpMyAdmin prompts this question, there is a line of English prompt in the lower right corner, which roughly means to solve this problem, you can refer to the phpMyAdmin document. Click this link and phpMyAdmin will automatically find the following instructions:

[2, 1.16] I cannot upload big dump files (memory, http or timeout problems ).
Starting with version 2.7.0, the import engine has been re-written and these problems shocould not occur. If possible, upgrade your phpMyAdmin to the latest version to advantake tage of the new import features.

The first things to check (or ask your host provider to check) are the values of upload_max_filesize, memory_limit and post_max_size in the php. ini configuration file. all of these three settings limit the maximum size of data that can be submitted and handled by PHP. one user also said that post_max_size and memory_limit need to be larger than upload_max_filesize.

The above file roughly indicates that when a large file is imported, first check php. upload_max_filesize, memory_limit, and post_max_size in the following three parts of the ini configuration file. We recommend that you modify the value slightly greater than the imported large SQL database file. Follow this prompt, I modified the above three in php. after the value in ini, the php environment is restarted. During the next import, although phpMyAdmin still shows the maximum import limit: 20,480 KB, the huge 80 Mb database file has been successfully imported.

PhpMyAdmin with a higher version can correctly display the maximum limit, which is generally the value of post_max_size.