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

Help
2013-12-30
2014-01-16
  • Didier Misson
    Didier Misson
    2013-12-30

    Hello,
    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.
    ;-)
    Didier

     
  • 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

      Hello

      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 ?

      Thanks
      ;-)
      Didier

       
  • 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.
    ; http://php.net/upload-max-filesize
    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 ?

    Thanks,
    Didier

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

    Thanks.

     
  • 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.
    ;-)