Articles in this section

How to increase upload dump size for phpMyAdmin in Plesk?

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)
  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%admin\conf\php.ini file and set the following values greater than the dump file size:

    CONFIG_TEXT: 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
For Linux (click to expand)
  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:

    CONFIG_TEXT: 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.

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.