Why phpMyAdmin file size limit is not changing?

Question

I'm using WAMP Server and here trying to upload a sql file with the file size of 131 MB.

The current limit is showing 128MiB on phpMyAdmin upload screen.

But my php.ini configuration was:

upload_max_filesize = 2M
post_max_size = 2M

That was a bit awkward to me. But then, I changed them to:

upload_max_filesize = 256M
post_max_size = 256M

And still it's showing (Max: 128MiB) limit.

The file I'm editing is in "C:\wamp\bin\apache\apache2.4.9\bin\" directory and I did restarted the server after changing those values.

I found a workaround of this issue by typing mysql commands in cmd. But my question is, why it's not reflecting my changes here?

Answer 1

I have finally found out how to do that. PhpMyAdmin has its own settings here

C:\wamp64\alias\phpmyadmin.conf

1. now you just change

       php_admin_value upload_max_filesize 512M
       php_admin_value post_max_size 512M
       php_admin_value max_execution_time 360
       php_admin_value max_input_time 360 

2. restart All services in Wamp
3. enjoy your day

Answer 2

With WAMP, you need to modify the variable upload_max_filesize in the php.ini files of PHP and Apache, which are located under :

• C:\wamp\bin\apache\apache2.4.9\bin\
• C:\wamp\bin\php\phpX.X.X

Answer 3

You have to change the value in this file:

wamp\alias\phpmyadmin.conf

Why they buried this configuration here among also having seperate php.ini files is a mystery to me.