can't upload DB file > 2MB (php.ini is ok)

  • Didier Misson

    Didier Misson - 2013-12-30

    I can't upload a SQL request > 2MB with Adminer 3.7.1.

    My server is a OpenVZ (Proxmox) Contener with Ubuntu 12.04 LTS.

    Of course, I have modify /etc/php5/apache2/php.ini :

    I put :
    memory_limit = 260M
    post_max_size = 22M
    upload_max_filesize = 22M

    but I can't yet upload the file (13 MB)

    Adminer always display :

    "File upload: (< 2MB)"

    I install phpMyAdmin, and I don't have this 2 MB limite !
    I succeed to upload my 13 MB DB with phpMyAdmin,
    but I want to be able to upload it with ADMINER...

    What can I check or try ?

    Thanks for your help.

  • Jakub Vrána

    Jakub Vrána - 2014-01-01

    This is the relevant code that Adminer prints:

    (< ' . ini_get("upload_max_filesize") . 'B)'

    Perhaps you modified upload_max_filesize just for the directory where is Adminer.

    • Didier Misson

      Didier Misson - 2014-01-01


      Just for the directory where is Adminer ?

      How can I do this ?

      And also... why ?
      No need to this with phpMyAdmin.
      Why Adminer doesn't take this value ?


  • Jakub Vrána

    Jakub Vrána - 2014-01-02

    You can set it e.g. in .htaccess. Adminer doesn't do anything special, the problem is probably in your web server configuration. I'm just trying to help you out but the problem is not in Adminer.

  • Didier Misson

    Didier Misson - 2014-01-15

    Max file size is not an Adminer problem.

    I run a "info.php", and found this :

    upload_max_filesize 2M

    but I changed this in /etc/php5/apache2/php.ini a long time ago :

    ; Maximum allowed size for uploaded files.
    upload_max_filesize = 22M

    I use webmin / virtualmin.
    I also find a configuration with 2M.
    I update it to 22M ...
    Of course, I restart Apache2, but no change.
    Always limited to 2M :-(

    So ... why Adminer and info.php keep this limit to 2M ?

    Where can I look ?


  • Jakub Vrána

    Jakub Vrána - 2014-01-15

    phpinfo() shows you the list of config files read. Also look for .htaccess file and <Directory> settings in your Apache configuration.

  • Didier Misson

    Didier Misson - 2014-01-15

    But which .htaccess ?
    I have no .htaccess in the Adminer folder ...

    The Apache configuration ?
    No "max size" in the /etc/apache2/apache2.conf

    I check other files in /etc/apache2 ...
    I don't see any size limite.


  • Didier Misson

    Didier Misson - 2014-01-16

    I find it !

    It'a due to Virtualmin / Webmin .

    In virtualmin, for this website,
    in Service / PHP5 Configuration / Ressource Limit ... I see 2M

    So, it's a limite, site by site, due to Virtualmin.

    I change it, and now Adminer limite is 22M, as I want.


Log in to post a comment.