phpMyAdmin Download phpMyAdmin Import data Max 2M solution

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

  • 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.