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 to modify the c: windowsphp. ini file. If it is a Win2000 machine, it should be cwinntphp. ini. Open the php. ini file with the WordPad: 1. Find p

This method is not desirable in the network, but can be implemented locally. Phpmyadmin: How can I change phpmyadmin to restrict the following methods? I have tried to 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. Find p

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!