Clever Geek Handbook

Why doesn't phpMyAdmin file size limit change?

I am using WAMP Server and trying to download sql file with 131MB file size.

The current limit shows 128MiB on the phpMyAdmin loading screen.

But my php.ini config was:

upload_max_filesize = 2M
post_max_size = 2M

It was a little uncomfortable for me. But then I changed them to:

upload_max_filesize = 256M
post_max_size = 256M

And yet it shows limitation (Max: 128MiB).

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

I found a workaround for this problem by typing mysql commands in cmd. But my question is, why doesn't it reflect my changes here?

+4


source to share


4 answers


I finally figured out how to do it. PhpMyAdmin has its settings here

C: \ wamp64 \ alias \ phpmyadmin.conf



  • 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
  • reboot All services in Wamp
  • enjoy the day
+20


source


With WAMP you need to change the upload_max_filesize variable in the PHP and Apache php.ini files located at:



  • C: \ WAMP \ Bin \ Apache \ apache2.4.9 \ Bin \
  • C: \ WAMP \ Bin \ PHP \ phpX.XX
+1


source


You are changing the default for file upload in php. Example: the form where you upload files. The max for php is 2MB and if you want more you need to change it in php.ini where you did it. To change the size of the phpmyadmin file, maybe in phpmyadmin config, but if the file is so big, try loading another way?

0


source


You must change the value in this file:

wamp\alias\phpmyadmin.conf

Why they buried this configuration here, including with separate php.ini files, is a mystery to me.

0


source






More articles:


All Articles