A solution to phpmyadmin import of import file restrictions
- 2020-03-31 20:14:14
- OfStack
Search the Internet for the solution of the previous, most say to change the upload_max_filesize in php.ini, but after changing this, still prompted the problem; However, when phpmyadmin prompts for this problem, there is a line in English at the bottom right corner, which basically means, to solve this problem, you can refer to the phpmyadmin documentation; Click this link directly and phpmyadmin automatically finds 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 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) 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.
When you import a large file, check the following three places in the php.ini configuration file, upload_max_filesize, memory_limit, and post_max_size. Following this tip, I changed the above three values in php.ini, restarted the PHP environment, and when I imported again, the huge 80M database file was successfully imported, although phpmyadmin still showed the maximum import limit: 20,480 KB.
[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 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) 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.
When you import a large file, check the following three places in the php.ini configuration file, upload_max_filesize, memory_limit, and post_max_size. Following this tip, I changed the above three values in php.ini, restarted the PHP environment, and when I imported again, the huge 80M database file was successfully imported, although phpmyadmin still showed the maximum import limit: 20,480 KB.