Blog

How to increase the maximum upload limit in phpMyAdmin ?

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:

  1. phpMyAdmin – Error
  2. Incorrect format parameter

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

To increase the maximum upload limit in phpMyAdmin, you must increase the cPanel PHP max upload size and cPanel PHP max POST size values. The maximum value these limits can be increased to is 2047 M. If your import file is larger than 2047 M, you must import the database via the command line.

Step-By-Step Instructions-

  • 👉 Step-1. Log in to WHM as the root user.
  • 👉 Step-2. Navigate to “Home / Server Configuration / Tweak Settings” in WHM.
  • 👉 Step-3. Click on the PHP tab.
  • 👉 Step-4. For the “cPanel PHP max upload size” option, increase the upload limit to your desired value.
    • a. Values higher than 2047MB are not permitted.
  • 👉 Step-5. For the “cPanel PHP max POST size” option, increase the POST value to the same or higher.
    • a. Values higher than 2047MB are not permitted.
  • 👉 Step-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.



Share this post

Latest Posts
Follow Us
Get the latest news delivered daily!

Build Websites is India’s one of the fastest growing full-service digital marketing & website development agencies, offering Return of interest(ROI) oriented solution with budget comfort. Build Websites is a leading IT company in India since 2012 . Build Websites offers a wide range of services including custom web design & development, Web & Mobile application development, Domain & Web Hosting, marketing solution that all drive sell.

Contacts
Useful Links
Our Social Activities (Facebook)