Home  >  Article  >  Database  >  What should I do if phpMyAdmin cannot import a large database file?

What should I do if phpMyAdmin cannot import a large database file?

coldplay.xixi
coldplay.xixiOriginal
2020-07-20 16:01:462147browse

Solution to the problem that phpMyAdmin cannot import large database files: first modify [upload_max_filesize] in [php.ini]; then modify the relevant configuration files; then make the modified value slightly larger than the imported sql database file ;Finally restart the php environment.

What should I do if phpMyAdmin cannot import a large database file?

Solution to the problem that phpMyAdmin cannot import a large database file:

Most people say to modify php.ini upload_max_filesize, but after modifying this, this problem is still prompted; but when phpmyadmin prompts this problem, there is a line of English prompts in the lower right corner, which roughly means that 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.

The general description of the above file means that when encountering a file that is too large to be imported, 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 be slightly larger than the imported huge sql database file.

Following this prompt, I modified the above three values ​​in php.ini and restarted the php environment. When importing again, although phpmyadmin still showed the maximum import limit: 20,480 KB, it was a huge 80M database. The file has been successfully imported.

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

Related tutorial recommendations: phpmyadmin

The above is the detailed content of What should I do if phpMyAdmin cannot import a large database file?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn