phpMyAdmin Import data Max 2M Solution _php Instance

phpMyAdmin is a frequently used MySQL management tool, backup and restore is an important function of phpMyAdmin, when restoring the database often encountered a situation: phpMyAdmin restore the database when the maximum upload limit: 2,048 KB, The database is slightly larger and cannot be processed, or use other backup-restore tools such as the imperial Backup King, or split-volume export, then is there any way to use phpMyAdmin to deal with it? Sure you can, follow the steps below.

Take the WINDOWS2003 system as an example, a total of three parts: the IIS part, the PHP part and the phpMyAdmin part.

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.

Second, PHP part

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.

Third, phpMyAdmin part

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.

Through the above three parts of the modification, you can perfectly solve the phpMyAdmin import data maximum of 2M problem.