How to Increase MySQL Database Upload Limit in PhpMyAdmin via WHM

When working with large databases, default upload limits in PhpMyAdmin can hinder progress. This guide shows you how to increase the MySQL database upload limit using WHM’s Tweak Settings.

Why Adjust Upload Limits?

New servers often have restrictive defaults (e.g., 2MB). Increasing these limits lets you upload larger SQL files (backups, exports) seamlessly.

 Step 1:

Log Into WHM
Access your Web Host Manager (WHM) dashboard using:
`https://your-server-ip:2087`
Enter your credentials to log in.

Step 2:

Navigate to Tweak Settings
1. Use the search bar at the top of WHM.
2. Type `Tweak Settings` and press Enter.
3. Click on the Tweak Settings option that appears.

 Step 3:

Modify PHP Upload Limits
In the Tweak Settings page:
1. Locate the PHP tab and click it.

2. Find these two settings:
– cPanel PHP max POST size
– cPanel PHP max upload size

3. Adjust both values to your desired limit (e.g., 512 for 512MB).
– Minimum: 55 | Maximum: 2,047 (in MB).
4. Scroll down and click Save.

 Step 4:

Verify Changes
Return to PhpMyAdmin. You can now upload SQL files up to your new limit (e.g., 512MB).

—

 Key Notes:
– Impact: These settings apply server-wide, affecting all cPanel accounts.
– Security: Avoid excessively high values (e.g., >1024MB) unless necessary.
– Alternative: For single-account adjustments, use cPanel’s `MultiPHP INI Editor`.

By following these steps, you’ll eliminate upload barriers and streamline database management.