Solution for PHPMYADMIN to import data up to 2 MB

Source: Internet
Author: User
Tags form post metabase

PHPMYADMIN is a frequently used MySql management tool. Backup and restoration are important functions of PHPMYADMIN. You often encounter this situation when restoring a database: the maximum size of data uploaded when PHPMYADMIN restores the database: 2,048 KB. If the database is a little larger, it cannot be processed. You can either use other backup and restoration tools, such as the imperial backup master or export data in separate volumes, is there any way to use PHPMYADMIN for processing? Certainly. follow the steps below.

Taking WINDOWS2003 as an example, there are three parts: IIS, PHP, and PHPMYADMIN.

I. IIS Section

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.

Ii. PHP part

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.
3. Find upload_max_filesize, that is, the maximum size of the file that can be uploaded. The default value is 2 MB.
If you want to upload a file larger than 8 Mb, you can set only the above three 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.

Iii. PHPMYADMIN

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.

The above three changes can perfectly solve the problem that PHPMYADMIN imports data up to 2 MB.

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.