Phpmyadmin solution for importing SQL files larger than 2 MB

In phpmyadmin, the default imported database file can only be 2 MB or less, but most of our data files will be 2 MB or more. Let's take a look at several different solutions.

The simplest way is

In the PHPMYADMIN Section

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.

However, the above method does not solve this problem for iis and php. ini which limits the upload size. Let's take a look at the solution under iis.

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. Solutions in PHP. ini

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.

In this case, you need to restart your apache. If it is an iis server, you can start iis. If it does not take effect, the above is probably because of php. ini limits the size of the uploaded file as long as php. ini or iis does not need to be modified anywhere in phpmyadmin.