Break through the phpMyadmin file size limit of 2 MB

Source: Internet
Author: User
Break through the phpMyadmin file size limit of 2 MB when using phpMyadmin to import the database, because the response time of the script during the upload is too long, resulting in data larger than 2 MB may occasionally fail to import. In addition, most default settings can only import 2 MB of data. In this case, we can modify the $ me corresponding to PHP. ini and import. php to break through the limit of 2 MB for phpMyadmin to upload files.

When using phpMyadmin to import data to the database, because the response time of the script during upload is too long, data larger than 2 MB may occasionally fail to be imported. In addition, most default settings can only import 2 MB of data.

In this case

We can modify the size limit of $ memory_limit corresponding to PHP. ini and import. php. You can also directly import SQL files of any size on the server.

Here we will talk about the second method:

First, open the config. inc. php file under the phpMyAdmin root directory, and find

$cfg['UploadDir']

Change

$cfg['UploadDir'] = ‘ck-import’

Then, upload the database to the ck-import folder through FTP.

After saving the code, one more (web server upload directory) will be displayed on the phpMyadmin background operation page ). Select the database you want to import from the drop-down list to import large files:



?

Similarly, when backing up a database, you can directly save it on the server and modify the $ cfg ['savedir'] = 'backup 'parameter.

?

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.