How To Increase Max Upload Size In Phpmyadmin

Unlike its counterpart, DirectAdmin still requires some transmission modification in order to conform certain values exterior of the DirectAdmin panel. This makes DirectAdmin require a bit more easily-on noesis for those savvy with command lines and for those and those that aren't — this article is to tell y'all what to change and how to change.

The primary reason one may want to increment these values is for uploading databases directly through the PHPMyAdmin interface. In lodge to practise this, nonetheless, one must edit the used PHP version's php.ini to adjust the setting, and so restart the appropriate services. The examples given below apply to a DirectAdmin server using PHP-FPM as the PHP handler.

Find the default PHP version'south php.ini

Yous can run the following command to find out what configuration files are in use on your server and what their locations are:

                                  /usr/local/directadmin/custombuild/build used_configs

PHPMyAdmin on DirectAdmin volition apply the default PHP version. There may be a bare php.ini department in the output of the control above, but you can ignore that equally we simply want to know the default PHP version and the location of its php.ini file.

Edit the php.ini upload filesize

Now that you can see the location of the default PHP version's php.ini file, you tin now edit information technology to increase the post_max_size and the max_upload_filesize variables.

We'll apply 256mb for the sake of the example

post_max_size = 256mb
upload_max_filesize=256mb

Now that you have the value you desire to fix then using the instance in the image above, you could use this command via SSH as root to edit the file:

                                  nano /usr/local/php73/lib/php.ini

Note that the upload_max_filesize determines the Mib displayed in PHPMyAdmin, but you'll want to increase both of the values.

Now you need to restart the webserver and any related services to ensure the changes accept identify.

Apache:

                                  service httpd restart

If using php-fpm, restart it (replace XX with the appropriate version of PHP, e.g., php-fpm73):

                                  systemctl restart php-fpmXX

Cheque your upload filesize

At present you tin can log into PHPMyAdmin and confirm that the value has been increased as desired by checking under the Import tab.

Increasing Max Upload Filesize and Post Max size in DirectAdmin's PHPMyAdmin

Determination

All in all, adjusting the configuration to let for a higher upload filesize in PHPMyAdmin is rather straightforward, and although a lilliputian technical — it shouldn't exist scary at all. We promise that this has helped you in adjusting these two values.

KnownHost offers 365 days a twelvemonth, 24 hours a mean solar day, all 7 days of the week best in course technical back up. A dedicated team is ready to help you should you need our assistance. You're non using KnownHost for the best spider web hosting experience? Well, why not? Bank check with our Sales team to encounter what can KnownHost do for you in improving your web hosting experience.