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.
- 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%adminconfphp.ini
file and set the following values greater than the dump file size: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
- 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:upload_max_filesize = 200M
post_max_size = 200M - Increase
client_max_body_size
on nginx as well, set the following values greater than the dump file size:# echo 'client_max_body_size 256m;' > /etc/nginx/conf.d/aa_client_max_body.conf
- 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.