phpMyAdmin is a frequently used MySQL management tool, backup and restore is an important function of phpMyAdmin, in the restoration of the database often encountered such a situation: phpMyAdmin restore the database when the maximum upload limit: 2,048 KB, If the database is a little larger, you can't handle it, or you can use a different backup restore tool such as the imperial Backup King, or the split-volume export, is there any way to use phpMyAdmin to handle it? Sure you can, follow the steps below.
Taking the WINDOWS2003 system as an example, it is divided into three parts: the IIS section, the PHP section, and the phpMyAdmin part.
First, the IIS section
1) To resolve the inability to upload bulk files in IIS 6.0:
1. Close the IIS Admin Service services in the service first.
2. Find the MetaBase.xml file under windows/system32/inetsrv/.
3, open with WordPad, find aspmaxrequestentityallowed to modify it to the desired value (the default is: 204800, that is: 200K).
4. Save the IIS Admin Service and restart IIS.
2) Workaround in IIS 6.0, you cannot download more than 4M attachment steps:
1. Close the IIS Admin Service services in the service first.
2. Find the MetaBase.xml file under windows/system32/inetsrv/.
3, open with WordPad, find aspbufferinglimit to modify it to the desired value (the default is: 4194304, that is: 4MB).
4. Save the IIS Admin Service and restart IIS.
Second, the PHP part
1, find post_max_size, refers to through the form post to PHP can receive the maximum value, including all the values in the form, the default is 8M, see you need to change.
2, find file uploads, first confirm file_uploads = on, whether to allow the switch to upload files via HTTP, the default is on is on.
3. Find upload_max_filesize; that is, the maximum size allowed for uploading files. The default is 2M.
If you want to upload >8m files, then only set the above three items can not be sure. It is best to set the following parameters as well:
Find max_execution_time = 600; The maximum time value (in seconds) for each PHP page to run, default 30 seconds.
Max_input_time = 600; The maximum time required for each PHP page to receive data, default 60 seconds.
Memory_limit = 8M; The maximum memory eaten by each PHP page, the default 8M.
Third, phpMyAdmin part
Open import.php file with WordPad:
1, find $memory_limit, the default is $memory_limit = 2 * 1024 * 1024;
2, the bottom three or four line position has the same statement, modifies itself.
Through the above three parts of the modification, can be a perfect solution to the phpMyAdmin import data 2M maximum problem.
The above describes the phpMyAdmin download phpMyAdmin import data up to 2M resolution, including the content of the phpMyAdmin download, I hope to be interested in PHP tutorial friends helpful.