Increase the Upload Size for MySQL Database on cPanel with phpMyAdmin using WHM

cPanel/WHM Server imposes a limit on the size of a mysql database that can be imported into phpMyAdmin. The default size is 50MB.

The best way to navigate this limitation is to make some tweaks in the WHM interface. Sometimes editing a php.ini file doesn’t make a difference.

 - Log into your WHM interface and type Tweak in the search bar.

The Tweak settings appear, in the find field on the right type: upload size

Change the cPanel PHP max upload size to what you need and save.

Go back to Tweak Settings and in the find bar type: post

Tweak Post Size CPanel

Change the cPanel PHP max POST size to what you need

That’s it, now you can import a larger database directly into phpMyAdmin, go back and change back to the default settings if required.