PhpMyAdmin imports database files with a data volume greater than 8 MB

This method is not desirable in the network, but can be implemented locally.

 

How can I change the phpMyAdmin restrictions when importing a database with a limit of more than 2 MB? I have tried the following methods ......

1. Modify the c: \ windows \ PHP. ini file.
If it is a Win2000 machine, it should be c \ winnt \ PHP. ini. Open the php. ini file with the WordPad:

1. Search for post_max_size, which refers to the maximum value that can be received by the form post to PhP, including all values in the form. The default value is 8 Mb. You need to change it.
2. Search for file uploads. First, check file_uploads = on; whether to allow file upload over HTTP. The default value is on. Upload_tmp_dir;
Find upload_max_filesize; that is, the maximum file size that can be uploaded. The default value is 2 MB.
3. If you want to upload a file larger than 8 Mb, you can set only the above four items. It is best to set the following parameters:
Query max_execution_time = 600; maximum time (in seconds) for running each PHP page. The default value is 30 seconds.
Max_input_time = 600; maximum time required for receiving data on each PHP page. The default value is 60 seconds.
Memory_limit = 8 m; maximum memory consumed by each PHP page. The default value is 8 m.

2. Modify the c: \ phpMyAdmin \ import. php file.
Open the import. php file on the WordPad:
1. Search for $ memory_limit. The default value is $ memory_limit = 2*1024*1024. Modify it by yourself.
2. Modify the statements at the same position in the following three lines.

3. This is not the case yet. It is a problem with IIS.
Phpma.com

1) solution to failure to upload large-capacity files in IIS 6.0:
1. Disable the IIS Admin Service in the service.
2. Find the metabase. xml file under windows \ system32 \ inetsrv.
3. Open it on the WordPad and find aspmaxrequestentityallowed to change it to the desired value (default value: 204800, that is, 200 K ).
4. Save the disk, restart the IIS Admin Service, and restart IIS.

2) solve the following steps:
1. Disable the IIS Admin Service in the service.
2. Find the metabase. xml file under windows \ system32 \ inetsrv.
3. Open it on the WordPad and find aspbufferinglimit to change it to the desired value (default value: 4194304, that is, 4 MB ).
4. Save the disk, restart the IIS Admin Service, and restart IIS.

OK. In the above three steps, the limit of 2 m for PHP is fully handled!

Also, do not forget to change the limit back to avoid the destruction of those who are interested in it!