phpMyAdmin Importing (Import) file limitations solution _php Tips

To the Internet search for the predecessors of the solution, most of them said to modify the php.ini in the upload_max_filesize, but modified this later, or prompted the problem; but phpmyadmin in the tip of the question, there is a line in the lower right corner of English prompts, the general meaning is to say, To solve this problem, you can refer to the phpMyAdmin document, click on this link directly, phpMyAdmin automatically find 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 has been re–written and this problems should not occur. If possible, upgrade your phpMyAdmin to the latest version to take the new import advantage.

The "Things to check" (or ask your host provider to check) are the values of Upload_max_filesize, Memory_limit and POS T_max_size in the php.ini configuration file. All this three settings limit the maximum size of data that can is submitted and handled by PHP. One user also said that Post_max_size and memory_limit need to be larger than.

The above document generally means that when you encounter a large import file, first check the following three places in the php.ini configuration file, Upload_max_filesize, Memory_limit and Post_max_size, and recommended that the modified value slightly larger than the import of the huge SQL database files; According to this prompt, I modified the above three values in php.ini, restart the PHP environment, import again, although phpMyAdmin still show the import maximum limit: 20,480 KB, However, the huge 80M database files have been successfully imported.