How to Increase the Upload Size of MySQL Database in PhpMyAdmin on a cPanel Server?

Posted on October 25th, 2018

How to Increase the Upload Size of MySQL Database in PhpMyAdmin on a cPanel Server?

The cPanel server imposes a limit for the database which can be uploaded into PhpMyAdmin. The default limit is limited to 50MB. In this case, it will be very difficult to upload a large database to PhpMyAdmin. To cover this up we can increase the upload size of the database file in the PhpMyAdmin. For this, you will have to change some values in the WHM of your server. In this tutorial, let’s have a look at how we can increase the import file size in PhpMyAdmin.

1) Login to the WHM of your server by accessing the link https://yourIPaddress:2087 or https://yourserverhostname:2087

2) Navigate to “Server Configuration”.

Increase upload size

 

3) Select “Tweak Settings” from it.

Increase upload size

 

4) Navigate to PHP in Tweak settings.

Increase upload size

 

Here you can see cPanel max POST size and cPanel max upload size values, change the values according to your preferred and save it. Now login to your PhpMyAdmin and verify the values, there you can see the value will be replaced with the changed one.

You can perform the same procedure via the CLI also.

1) Login to your server via SSH.

# ssh root@IPaddress

2) Execute the following command, which will display the default PHP ini file of your server.

# php –ini

3) Open it with your favorite text editor.

# vi path_to_php.ini (Replace this with the original file path)

4) Search for the upload and post. There you can see entries like the following.

upload_max_filesize =  M

post_max_size =  M

Change both the values with your preferred value.

5) Finally, restart the apache service.

# service httpd restart    or

# systemctl restart httpd

Thus we have learned how to increase the upload size in PhpMyAdmin.

 

If you have any doubt regarding this, please do reach our support department via Live chat or support ticket.

 

Leave a Reply