Modify the size limit of the phpMyAdmin import SQL file

When importing MySQL database with phpMyAdmin, my 10M database cannot be imported, which indicates that the MySQL database can only import 2M.

phpMyAdmin Database Import Error:

You probably tried to upload too large file. Refer to documentation for ways-workaround this limit.

Can I modify the maximum import database file limit?

To the online search for the previous solution, most of them said to modify the php.ini in the upload_max_filesize, but after the modification of this, or prompt this question, but phpmyadmin in the prompt this question, the right corner has a line of English hints, roughly meaning that, To solve this problem, you can refer to the phpMyAdmin document, click the link directly, phpMyAdmin automatically found the following instructions:

[1.16] I cannot upload big dump files (memory, HTTP or timeout problems).
Starting with version 2.7.0, the import engine had been re–written and these problems should not occur. If possible, upgrade your phpMyAdmin to the latest version to take advantage of the new import features.

The first things to check (or ask your host provider to check) is the values of Upload_max_filesize, Memory_limit and POS T_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data the can is 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 generally means that, when encountering a large file import, first check the following three places in the php.ini configuration file, Upload_max_filesize, Memory_limit and Post_max_size, and recommended to modify the value of slightly larger than the import of large SQL database files; Following this hint, I modified the above three values in php.ini, restart the PHP environment, import again, although phpMyAdmin still display the maximum import limit: 20,480 KB, However, the huge 80M database file has been successfully imported.

The phpmyadmin of the version highs can display the maximum limit correctly, which is generally the value of post_max_size.

Modify the size limit of the phpMyAdmin import SQL file