Are you struggling to upload large database files in phpMyAdmin? Here’s the complete, working solution that many tutorials miss!

The Critical Settings You Need to Change

In WHM’s Tweak Settings, there are TWO essential settings that work together to increase your phpMyAdmin upload limit:

🔑 Key Settings in WHM Tweak Settings:

1. cPanel PHP max upload size
   • Default: 50
   • Recommended: 2000 (for 2GB)
2. ⚠️ MOST IMPORTANT: cPanel PHP max POST size
   • Default: 55
   • Recommended: 2000 (for 2GB)
   • This is the critical setting many guides miss!

Step-by-Step Solution

 

1. Log into WHM (Web Host Manager)
2. Navigate to “Server Configuration” → “Tweak Settings”
3. Find the PHP section
4. Update BOTH settings:
   • Set “cPanel PHP max upload size” to 2000
   • Set “cPanel PHP max POST size” to 2000 (This is crucial!)
5. Click “Save” at the bottom of the page

Why Both Settings Matter

• The upload size controls how large a file can be
• The POST size determines how much data can be sent in a single request
• Important: Even if you increase the upload size but leave the POST size small, your uploads will still fail!

Verification

After changing these settings, you should see this confirmation:

Best Practices

1. Always set POST size equal to or slightly larger than upload size
2. Keep regular backups before attempting large imports
3. Consider compressing (.gz) large database files before upload
4. Monitor server resources during large imports

Common Mistakes to Avoid

❌ Only changing the upload size ❌ Modifying php.ini without updating POST size ❌ Forgetting to check both settings ✅ Always update both upload AND POST size settings

Need More Help?

If you’re still experiencing issues after updating both settings:

1. Clear your browser cache
2. Log out and back into phpMyAdmin
3. Verify changes through phpinfo()

Have you successfully increased your phpMyAdmin upload limits? Share your experience in the comments below!