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

0
3318

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.

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.

 

Cpanel PhpMyAdmin uses the php.ini file /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini.

To increase upload limit, change values of upload_max_filesize and post_max_size in this php.ini file. Typically, you may set value of post_max_size to twice the value of upload_max_filesize. For example, to import SQL files up to 250MB size, set upload_max_filesize to 250MB and post_max_size to 500MB.

You may also want to change values of max_execution_time and memory_limit.

 

Good luck .