CODEWITHSUNDEEP
mysqlphpmyadmin
macmohr
macmohr

Reputation: 21

Trying to increase file upload limit for phpmyadmin

I'm having an issue with phpmyadmin where the max file upload size stays constant at 128MiB. I have read other issues extensively and have already run phpinfo() to make sure i'm loading the right file. The ini files it is loading are:

Configuration File (php.ini) Path = C:\Windows
Loaded Configuration File = C:\wamp\bin\apache\apache2.4.9\bin\php.ini

These files have been updated so that the following parameters are as follows:

Further more the phpinfo() function returns these values for both local and master values. Additonally, I am using wamp server and have not only restarted all the services as well as restarted my computer. Despite this the phpmyadmin file upload function stays at 128MiB.

The reason this is an issue is due to the fact the data I need to import is an extremely large .csv the current one is 350MB however I expect to have to import one that is at least 3GB. I'm completely at a loss as to how I should continue with this.

Upvotes: 2

Views: 9190

Answers (1)

Josip Ivic
Josip Ivic

Reputation: 3709

Find the php.ini file.

Find this and change it:

post_max_size = 128M

Change the values of theese like this 

memory_limit = 2000M
post_max_size = 4000M
upload_max_filesize = 5000M

Restart apache, and you are good to go.

EDIT:

As you can see, memory_limit is lower than post_max_size that is lower than upload_max_filesize. You need to put values like these in order to workaround upload.

Upvotes: 0

Related Questions