Plesk

How to increase upload dump size for phpMyAdmin in Plesk?

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. 

  1. Log in the server via  RDP.

    Note: if direct RDP access to the server is not possible, contact server administrator for further assistance.

  2. 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

  3. Go to IIS (Internet Information Services) > Application Pools then Stop and Start PleskControlPanel pool.
  4. Go to IIS (Internet Information Services) > Sites > pleskcontrolpanel > Restart
  1. Log in the server via SSH.

    Note: if direct SSH access to the server is not possible, contact server administrator for further assistance.

  2. 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

  3. 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

  4. 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.