phpMyAdmin resolve to import more than 2MB SQL file method

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.