phpMyAdmin resolve to import more than 2MB SQL file method

Source: Internet
Author: User
Keywords Web programming MySQL Tutorial
Tags admin service change data database file default different file files

The default import database file in phpMyAdmin can only be within 2MB, but our data files will be above 2MB for most of the time, so let's look at a couple of different solutions.
The easiest way to do this is to

In the phpMyAdmin section

To open the import.php file with WordPad:
1, find $memory_limit, default for $memory_limit = 2 * 1024 * 1024;
2, the bottom three or four line position has the same statement, own modification.

But the above method for Iis,php.ini Limited upload big is no way to solve this problem, let's look at the solution under IIS


Part of the IIS

1 Solution in IIS 6.0, unable to upload a large-capacity file method:
1, first in the service to shut down the IIS Admin Service services.
2, find windows/system32/inetsrv/under the MetaBase.xml file.
3, with WordPad Open, find aspmaxrequestentityallowed to change it to the desired value (the default is: 204800, that is, 200K).
4, Save and restart IIS Admin service.

2 to resolve in IIS 6.0, cannot download the attachment step exceeding 4M:
1, first in the service to shut down the IIS Admin Service services.
2, find windows/system32/inetsrv/under the MetaBase.xml file.
3, with WordPad Open, find aspbufferinglimit to change it to the desired value (the default is: 4194304, that is, 4MB).
4, Save and restart IIS Admin service.

Ii. Solutions in PHP.ini

1, find post_max_size, refers to the form post to PHP can receive the maximum value, including all the values in the form, the default is 8M, see you need to change.
2, look for file uploads, first confirm file_uploads = on; whether to allow the switch to upload files via HTTP, by default on is open.
3, find upload_max_filesize, that is, the maximum size of the upload file allowed. The default is 2M.
If you want to upload >8m files, then only set the above three items can not be sure. It is best to set the following parameters:
Find Max_execution_time = 600, maximum time (in seconds) for each PHP page to run, default 30 seconds.
Max_input_time = 600, the maximum time required for each PHP page to receive data, default 60 seconds.
Memory_limit = 8M; The maximum memory consumed by each PHP page, the default 8M.

Then you need to reboot your Apache Oh, if IIS server can start IIS if it's not going to work! Summing up the above is probably because the php.ini limit the size of the upload file as long as the processing php.ini or IIS does not need to modify the phpMyAdmin anywhere.

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.