Modify the size limit of the SQL file imported by phpMyAdmin

Source: Internet
Author: User

When using phpMyAdmin to import a mysql database, my MB database cannot be imported, prompting that the mysql database can only be imported at most 2 MB.

An error occurred while importing the phpMyAdmin database:

You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

Can I modify the maximum limit of imported database files?

I searched the internet for solutions from our predecessors. Most of them mentioned modifying php. upload_max_filesize in ini, but after this is modified, this question is still prompted; but when phpMyAdmin prompts this question, there is a line of English prompt in the lower right corner, which roughly means to solve this problem, you can refer to the phpMyAdmin document. Click this link and phpMyAdmin will automatically find the following instructions:

[2, 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 shocould not occur. If possible, upgrade your phpMyAdmin to the latest version to advantake tage 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 above file roughly indicates that when a large file is imported, first check php. upload_max_filesize, memory_limit, and post_max_size in the following three parts of the ini configuration file. We recommend that you modify the value slightly greater than the imported large SQL database file. Follow this prompt, I modified the above three in php. after the value in ini, the php environment is restarted. During the next import, although phpMyAdmin still shows the maximum import limit: 20,480 KB, the huge 80 Mb database file has been successfully imported.

PhpMyAdmin with a higher version can correctly display the maximum limit, which is generally the value of post_max_size.

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.