Yeah well, sometimes we are too lazy to manipulate database information on the server through the command line, so we can just use a graphical user interface. PHPMyAdmin is without a doubt the best tool for this, as it allow us to see all the databases available on the server (as long as we have access to them), modify their structure, tables etc. One of those useful features, is the possibility to import a database from a .sql,.zip from your computer via web. The problem is basically, when you have large database backups whose size is higher than 2MB, because that's the limit imposed on the
php.ini configuration used by plesk:
1. Edit Plesk Admin php.ini
On PHP, the solution for this problem is to simply adjust the configuration properties of
upload_max_filesize in the php.ini file. In Plesk, the used configuration file is located at
/usr/local/psa/admin/conf/php.ini. You are free to modify this file as you want, you can use a terminal based text editor or download the file via SFTP and upload it later.
In our case, we will edit it using nano in our terminal:
Then, register the new properties on the file in case they doesn't exist already with the new values that you want, in our case we will set both with 64MB:
In the terminal our file will look like:
Save the changes to the file and proceed with the next step.
2. Restart Plesk Web Server
Finally, to make the changes take effect, you will need to restart the plesk web server running the following command:
It shouldn't take so long and you will be able to check immediately the new max allowed upload file size:
Happy coding !