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 above describes the phpMyAdmin imported import file limitations of the solution, including the aspects of the content, I hope that the PHP tutorial interested in a friend helpful.
