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

Source: Internet
Author: User
Tags form post metabase
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!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.