# How to increase upload limit for PhpMyAdmin

**URL:** <https://forums.interworx.com/t/how-to-increase-upload-limit-for-phpmyadmin/15376>\
**Category:** General Discussion\
**Created:** [October 19, 2019, 1:08pm UTC](https://forums.interworx.com/t/how-to-increase-upload-limit-for-phpmyadmin/15376 "2019-10-19T13:08:00Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nico](https://forums.interworx.com/letter_avatar_proxy/v4/letter/n/b5a626/32.png) [@Nico](https://forums.interworx.com/u/Nico)\
**Post date:** [October 19, 2019, 1:08pm UTC](https://forums.interworx.com/t/how-to-increase-upload-limit-for-phpmyadmin/15376/1 "2019-10-19T13:08:00Z")

</div>

Hi All,  
Where can I change the upload limit in PhpMyAdmin from 128mb to 256mb?  
Kind regards,  
Nico

---

<div class="post-metadata">

**Author:** ![d2d4j](https://forums.interworx.com/user_avatar/forums.interworx.com/d2d4j/32/16_2.png) [@d2d4j](https://forums.interworx.com/u/d2d4j)\
**Post date:** [October 20, 2019, 1:12am UTC](https://forums.interworx.com/t/how-to-increase-upload-limit-for-phpmyadmin/15376/2 "2019-10-20T01:12:07Z")

</div>

Hi nico

I hope your well

Please see below a post I made for increasing myphpadmin size

Many thanks

John

[QUOTE=d2d4j;4786]Hi

Just a quick post to help anyone wanting to increase the phpmyadmin upload to greater then 128Mb  
You need to SSH into your server and edit as root or use sudo  
vi ~iworx/etc/php.ini  
change the following settings  
post\_max\_size =  
upload\_max\_filesize =  
memory\_limit =  
Save  
If settings do not show, restart apache or restart server and check  
I hope that helps  
Many thanks  
John[/QUOTE]

---

<div class="post-metadata">

**Author:** ![Nico](https://forums.interworx.com/letter_avatar_proxy/v4/letter/n/b5a626/32.png) [@Nico](https://forums.interworx.com/u/Nico)\
**Post date:** [October 20, 2019, 2:36am UTC](https://forums.interworx.com/t/how-to-increase-upload-limit-for-phpmyadmin/15376/3 "2019-10-20T02:36:39Z")

</div>

Hi John,  
Many thanks, I probably do use the wrong wording to look on the forum and Gxxgle, sorry.

John, that file doesn’t exist somehow, I checked another server but same…  
I then tried to increase the ones in /etc/php.ini but no result either.

Kind regards,  
Nico

---

<div class="post-metadata">

**Author:** ![d2d4j](https://forums.interworx.com/user_avatar/forums.interworx.com/d2d4j/32/16_2.png) [@d2d4j](https://forums.interworx.com/u/d2d4j)\
**Post date:** [October 21, 2019, 3:56am UTC](https://forums.interworx.com/t/how-to-increase-upload-limit-for-phpmyadmin/15376/4 "2019-10-21T03:56:52Z")

</div>

Hi Nico

I have undeleted your thread

edit the following and make sure those 3 files are set correctly:

vi /etc/opt/iworx/iworxphp72/php.ini

Then increase size as needed from following file:

vi /etc/opt/iworx/iworxphp72/php.d/90-iworx-overrides.ini

save and run

service iworx restart

service httpd restart

check and all should be good

Many thanks

John

---

<div class="post-metadata">

**Author:** ![Nico](https://forums.interworx.com/letter_avatar_proxy/v4/letter/n/b5a626/32.png) [@Nico](https://forums.interworx.com/u/Nico)\
**Post date:** [October 22, 2019, 4:56am UTC](https://forums.interworx.com/t/how-to-increase-upload-limit-for-phpmyadmin/15376/5 "2019-10-22T04:56:48Z")

</div>

Hi John,  
Thank ever so much, I was now able to import the backup of the database, only to discover it was ‘old format’ and I had to put in an extra row with sql\_mode="" in /etc/my.cnf The problem I had was that users where not able to login the back-end/front-end of their website and I thought it was due to a failed import, seems in the past some fields could just be empty instead of NULL, and MariaDB seems to be more ‘strict’ All sorted now.  
Kind regards,  
Nico

---

<div class="post-metadata">

**Author:** ![anunciocarabobo](https://forums.interworx.com/user_avatar/forums.interworx.com/anunciocarabobo/32/209_2.png) [@anunciocarabobo](https://forums.interworx.com/u/anunciocarabobo)\
**Post date:** [October 24, 2019, 8:47am UTC](https://forums.interworx.com/t/how-to-increase-upload-limit-for-phpmyadmin/15376/6 "2019-10-24T08:47:32Z")

</div>

nico una pregunta d?nde pudiera yo cambiar el l?mite de carga en PhpMyAdmin de 128mb a 256mb?

---

<div class="post-metadata">

**Author:** ![Nico](https://forums.interworx.com/letter_avatar_proxy/v4/letter/n/b5a626/32.png) [@Nico](https://forums.interworx.com/u/Nico)\
**Post date:** [October 24, 2019, 11:24am UTC](https://forums.interworx.com/t/how-to-increase-upload-limit-for-phpmyadmin/15376/8 "2019-10-24T11:24:57Z")

</div>

@anunciocarabobo  
Hola, inicie sesi?n ssh como root y nano /etc/opt/iworx/iworxphp72php.d/90-iworx-overrides.ini

post\_max\_size = 256M  
upload\_max\_filesize = 256M  
memoria\_limit = 256M

Si su iworx php es una versi?n diferente, reemplace el 72 con su versi?n

entonces  
servicio reinicio iworx  
servicio httpd reiniciar  
En Nodeworx reinicie todos los servicios PHP-FPM  
hecho.

---

<div class="post-metadata">

**Author:** ![d2d4j](https://forums.interworx.com/user_avatar/forums.interworx.com/d2d4j/32/16_2.png) [@d2d4j](https://forums.interworx.com/u/d2d4j)\
**Post date:** [October 4, 2020, 7:18pm UTC](https://forums.interworx.com/t/how-to-increase-upload-limit-for-phpmyadmin/15376/10 "2020-10-04T19:18:01Z")

</div>

Unlisted on October 4, 2020, 7:18pm UTC



---

<div class="post-metadata">

**Author:** ![d2d4j](https://forums.interworx.com/user_avatar/forums.interworx.com/d2d4j/32/16_2.png) [@d2d4j](https://forums.interworx.com/u/d2d4j)\
**Post date:** [October 4, 2020, 7:19pm UTC](https://forums.interworx.com/t/how-to-increase-upload-limit-for-phpmyadmin/15376/11 "2020-10-04T19:19:53Z")

</div>

Listed on October 4, 2020, 7:19pm UTC



---

<div class="post-metadata">

**Author:** ![Edbert](https://forums.interworx.com/user_avatar/forums.interworx.com/edbert/32/2073_2.png) [@Edbert](https://forums.interworx.com/u/Edbert)\
**Post date:** [December 4, 2021, 7:48am UTC](https://forums.interworx.com/t/how-to-increase-upload-limit-for-phpmyadmin/15376/13 "2021-12-04T07:48:48Z")

</div>

I’m having this trouble too… but how do I access the SSH?

---

<div class="post-metadata">

**Author:** ![d2d4j](https://forums.interworx.com/user_avatar/forums.interworx.com/d2d4j/32/16_2.png) [@d2d4j](https://forums.interworx.com/u/d2d4j)\
**Post date:** [December 4, 2021, 10:28am UTC](https://forums.interworx.com/t/how-to-increase-upload-limit-for-phpmyadmin/15376/14 "2021-12-04T10:28:01Z")

</div>

Hi

Welcome to IW forums

Here are a couple of links to how to use SSH but any search on internet would find thousands of links

Many thanks

John

[Logging into Your Server via Secure Shell (SSH) (liquidweb.com)](https://help.liquidweb.com/s/article/Logging-into-Your-Server-via-Secure-Shell-SSH)

[New User Tutorial: Basic SSH Usage - Liquid Web](https://www.liquidweb.com/kb/new-user-tutorial-basic-ssh/)
