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

0
2330

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

 

Hello,

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.

tweak-settings-cpanel-databse

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

tweak-max-upload-size-cpanel

 

 

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.

 

Good luck