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

You are changing the default value for file upload in php. Example: form where you upload files. The default max for php is 2mb and if you want more you have to change it in php.ini where you did. To change the phpmyadmin file size maybe in the config of the phpmyadmin but if the file is so large maybe try to upload other way no?

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.

Answer 4

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