Solution for PHPMYADMIN to import data up to 2 MB

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.