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

[Didier Misson]

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]

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]

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]

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]

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]

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

[Didier Misson]

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]

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

[Solutions]

This has been more than 9 years, but I came by this and would like to help.

adminer relies on the php.ini configuration which should be at /etc/php/xx/apache2, then the most important step after saving the file, apache needs to be restarted, so use one of the commands:
/etc/init.d/apache2 restart OR
sudo /etc/init.d/apache2 restart OR
sudo service apache2 restart
Or you can reboot the server with the command:
reboot

After rebooting, all changed configuration will be applied, so if you check your phpinfo file, you will find all changes applied.