phpMyAdmin resolve to import more than 2MB SQL file method

The easiest way to do that 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 the problem, let's look at the solution under IIS

One, the IIS section

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 then restart the IIS Admin Service services, restart IIS.

2 to resolve in IIS 6.0, cannot download the attachment step of more than 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 then restart the IIS Admin Service services, restart IIS.

Ii. Solutions in the 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.