kb: how-to
ABT: Group B
Question
Maximum upload dump size is set to 2,048MiB in phpMyAdmin > Import > File to import
How to increase it?
Answer
Increase values in Plesk php config file according to needs.
For Windows (click to expand)
- Log in the server via RDP.
Note: if direct RDP access to the server is not possible, contact server administrator for further assistance.
- Edit
%plesk_dir%admin\conf\php.inifile and set the following values greater than the dump file size:CONFIG_TEXT: upload_max_filesize = 200M
post_max_size =200M - Go to IIS (Internet Information Services) > Application Pools then Stop and Start PleskControlPanel pool.
- Go to IIS (Internet Information Services) > Sites > pleskcontrolpanel > Restart
For Linux (click to expand)
- Log in the server via SSH.
Note: if direct SSH access to the server is not possible, contact server administrator for further assistance.
- Edit
/opt/psa/admin/conf/php.ini(for Debian, Ubuntu) or/usr/local/psa/admin/conf/php.ini(for CentOS, cloudLinux, RedHat) and set the following values greater than the dump file size:CONFIG_TEXT: upload_max_filesize = 200M
post_max_size = 200M - Run the following commands to restart services:
# service sw-engine restart
# service sw-cp-server restart
Try alternative solutions advised in the official phpMyAdmin documentation.
Comments
3 comments
Typo here, it's not:
sw-cp-server restart
but:
service sw-cp-server restart
thanks for the doc btw, it works for me with CentOS 7. ;)
Thank you Robin! Fixed the typo.
Hello, Unfortunately, the suggested values have created problems on a version of the Plesk panel:
Product version: Plesk Obsidian 18.0.35.2
OS version: CentOS 7.9.2009 x86_64
Build date: 2021/05/26 11:00
Revision: 79a8872782bd03d98ca90cda78a8ba20d1369c41
In fact, after the modification, which worked very well, the Plesk file manager gave error to each loading of the files, indicating that each file loaded (even the smallest) was too large. In the end I solved by changing the value from megabyte in bytes, i hope this can be usefull the community by suggestion.
Please sign in to leave a comment.