Get the most out of your Centmin Mod LEMP stack
Become a Member

Increase phpmyadmin upload limit

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by elargento, Jun 20, 2017.

  1. elargento

    elargento Member

    284
    16
    18
    Jan 4, 2016
    Ratings:
    +37
    Local Time:
    8:21 PM
    10
    Currently set at 768MiB (default centminmod phpmyadmin installation)

    I already increased post_max_size and upload_max_filesize in/usr/local/lib/php.ini to 9999M and upload size still the same

    Any ideas?
     
  2. eva2000

    eva2000 Administrator Staff Member

    29,051
    6,591
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,786
    Local Time:
    9:21 AM
    Nginx 1.13.x
    MariaDB 5.5
    if you installed phpmyadmin via centmin mod phpmyadmin.sh addon, it has it's own specific php-fpm pool user and custom settings at /usr/local/nginx/conf/phpfpmd/phpfpm_myadmin.conf defined
    Code (Text):
    php_admin_value[memory_limit] = ${MEMLIMIT}M
    php_admin_value[max_execution_time] = 3000
    php_admin_value[post_max_size] = 768M
    php_admin_value[upload_max_filesize] = 768M

    Where ${MEMLIMIT} would be dynamically calculated based on memory free/available at time of phpmyadmin.sh install run.
    Edit /usr/local/nginx/conf/phpfpmd/phpfpm_myadmin.conf and restart both nginx and php-fpm

    If import has errors due to size read https://centminmod.com/addon_phpmyadmin.html#importerrors

    If it's export size, read https://centminmod.com/addon_phpmyadmin.html#timeouts
     
  3. elargento

    elargento Member

    284
    16
    18
    Jan 4, 2016
    Ratings:
    +37
    Local Time:
    8:21 PM
    10
    set
    php_admin_value[post_max_size] = 9999M
    php_admin_value[upload_max_filesize] = 9999M

    ngxrestart and fpmrestart

    but it still the same in phpmyadmin...768MiB
     
  4. eva2000

    eva2000 Administrator Staff Member

    29,051
    6,591
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,786
    Local Time:
    9:21 AM
    Nginx 1.13.x
    MariaDB 5.5
    where you looking for reported 768MB value ? you'd need to set a phpinfo file in phpmyadmin install directory to see it's own value. If phpinfo file is outside of phpmyadmin install directory, then it reports the usual and separate php-fpm default settings.

    tested it myself and works for phpmyadmin install directory's loaded phpinfo file reported 9999MB values
     
    Last edited: Jun 20, 2017