phpMyAdmin Importing (Import) file limitations solution _php Tips

Source: Internet
Author: User
Tags phpmyadmin
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.