Shulou(Shulou.com)06/01 Report--

This article is to share with you about the solution that phpMyAdmin cannot import large database files. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The solution that phpMyAdmin cannot import a large database file is to first modify [upload_max_filesize] in [php.ini], then modify the relevant configuration file, then make the modified value slightly larger than the imported sql database file, and finally restart the php environment.

The solution to phpMyAdmin's inability to import large database files:

Most people say that the upload_max_filesize in php.ini is modified, but after modifying this, the question is still prompted. However, when phpmyadmin prompts this question, there is an English prompt in the lower right corner, which roughly means that you can refer to the phpmyadmin document to solve this problem. Click this link directly and phpmyadmin automatically finds the following instructions:

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.

The general description of the above file means that when you import a large file, first check the following three places in the php.ini configuration file, upload_max_filesize, memory_limit and post_max_size, and it is recommended that the modified value is slightly larger than the imported large sql database file.

Following this hint, I changed the above three values in php.ini and restarted the php environment. When importing again, phpmyadmin still shows the maximum import limit: 20480 KB, but the huge 80m database file has been successfully imported.

The version of phpMyAdmin used is 2.8.1, environment: APMServ 5.1.2

Thank you for reading! On "phpMyAdmin can not import large database files solution" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, you can share it out for more people to see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.