Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
cPanelResources

Tutorial How to increase the maximum upload limit in PHPMyAdmin

Increasing the maximum upload limit in phpMyAdmin

Tags:
  1. cPanelResources
    Note: Importing large databases via the command line is a faster and more reliable alternative to increasing the maximum upload limit for phpMyAdmin. Click here to learn how to import databases on the command line.

    Overview

    If a SQL file is uploaded through phpMyAdmin that exceeds the upload size limit and/or the post size limit, the following error will occur:
    Code:
    phpMyAdmin - Error
    Incorrect format parameter
    
    Screen Shot 2019-04-18 at 1.25.55 PM.png

    This error is provided because only part of the file was uploaded due to the upload limit which results in a corrupted import.

    It is required to increase the cPanel PHP max upload size and cPanel PHP max POST size values in order to increase the maximum upload limit in phpMyAdmin.

    The maximum value that these limits can be increased to is 2047M. If your import file is larger than 2047M, you must import the database via the command line.

    Step-By-Step Instructions
    1. Login to WHM as the root user.
    2. Navigate to: WHM Home »Server Configuration »Tweak Settings.
    3. Click on the PHP tab.
    4. For the "cPanel PHP max upload size" option, increase the upload limit to your desired value. Values higher than 2047MB are not permitted.
    5. For the "cPanel PHP max POST size" option, increase the POST value to the same or higher. Values higher than 2047MB are not permitted.
    6. Click Save.
    Once this is done, you'll see that phpMyAdmin now shows the new maximum upload size on the import screen next to the upload button:

    Screen Shot 2019-04-18 at 12.38.53 PM.png

    Questions/Feedback
    Feel free to click on the Discussion tab to let us know if you have any trouble with the instructions in this tutorial, or have additional questions and feedback.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice