# Hi Community I am not able to upload the database of 1.4GB in adminer Need your help

**URL:** https://community.kinsta.com/t/hi-community-i-am-not-able-to-upload-the-database-of-1-4gb-in-adminer-need-your-help/2595
**Category:** Application Support
**Created:** [October 19, 2023, 6:13pm UTC](https://community.kinsta.com/t/hi-community-i-am-not-able-to-upload-the-database-of-1-4gb-in-adminer-need-your-help/2595 "2023-10-19T18:13:26Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![alisukhera](https://sea2.discourse-cdn.com/flex020/user_avatar/community.kinsta.com/alisukhera/32/2524_2.png) [@alisukhera](https://community.kinsta.com/u/alisukhera)
#### Post date: [October 19, 2023, 6:13pm UTC](https://community.kinsta.com/t/hi-community-i-am-not-able-to-upload-the-database-of-1-4gb-in-adminer-need-your-help/2595/1 "2023-10-19T18:13:26Z")

</div>

I have increased these things in php.ini  
upload\_max\_filesize = 20480M  
post\_max\_size = 204800M  
upload\_max\_size = 20480M  
Here are the errors i am getting.  
**Warning** : POST Content-Length of 872024605 bytes exceeds the limit of 536870912 bytes in **Unknown** on line **0**

**Warning** : session\_cache\_limiter(): Session cache limiter cannot be changed after headers have already been sent in **/var/www/html/adminer.php** on line **172**

**Warning** : session\_name(): Session name cannot be changed after headers have already been sent in **/var/www/html/adminer.php** on line **172**

**Warning** : session\_set\_cookie\_params(): Session cookie parameters cannot be changed after headers have already been sent in **/var/www/html/adminer.php** on line **172**

**Warning** : session\_start(): Session cannot be started after headers have already been sent in **/var/www/html/adminer.php** on line **172**

**Warning** : Undefined global variable $\_SESSION in **/var/www/html/adminer.php** on line **176**

**Warning** : Undefined global variable $\_SESSION in **/var/www/html/adminer.php** on line **178**

**Warning** : Undefined global variable $\_SESSION in **/var/www/html/adminer.php** on line **178**

**Fatal error** : Uncaught Error: Undefined constant “SID” in /var/www/html/adminer.php:51 Stack trace: #0 /var/www/html/adminer.php(1413): sid() #1 /var/www/html/index.php(9): require\_once(‘/var/www/html/a…’) #2 {main} thrown in **/var/www/html/adminer.php** on line **51**

---

<div class="post-metadata">

### Author: ![ZachE](https://sea2.discourse-cdn.com/flex020/user_avatar/community.kinsta.com/zache/32/1683_2.png) [@ZachE](https://community.kinsta.com/u/ZachE)
#### Post date: [October 19, 2023, 11:39pm UTC](https://community.kinsta.com/t/hi-community-i-am-not-able-to-upload-the-database-of-1-4gb-in-adminer-need-your-help/2595/2 "2023-10-19T23:39:29Z")

</div>

Hi @alisukhera 👋

You will also need to adjust NGINX configuration to reflect `client_max_body_size 2G;` in order for NGINX to forward that much POST body to PHP

I think also you’ll want to adjust `post_max_size` and `upload_max_filesize` to `2048M` instead of 204GB 😅

Some previous solutions for this:

> [@Can't import 130mb database](https://community.kinsta.com/t/cant-import-130mb-database/483/7):
>
> DevKinsta has a default limitation on 128MB file upload. In order to get that increased you will need to access shell. It can be done by running docker exec -it devkinsta\_fpm bash This will bring you to the terminal of the application server. Depending on version of PHP you are using, file is located in /etc/php/7.4/fpm/conf.d/tuning.ini This is for version 7.4. If you need to edit file for different version you can simply change 7.4 in path with PHP version used. 3 values should be cha…

> [@How to Change upload\_max\_filesize in Windows](https://community.kinsta.com/t/how-to-change-upload-max-filesize-in-windows/1064/2):
>
> I use DevKinsta on Windows 11. I’ve been trying to change the upload\_max\_filesize in php.ini I’ve followed exactly these instructions: "1. Open Terminal on your Mac and type in docker exec -it devkinsta\_fpm bash 2. Type in apt-get update && apt-get upgrade && apt-get install nano. You will be prompted to type Y. This step will install nano so you can edit the file. 3. Then type in nano /etc/php/7.3/fpm/php.ini. You may need to change the 7.3 to another version. Match this with the version …

You can maybe also try compressing the .sql file with WinZIP or make a .tar.gz or .gz file (GZIP)

If those solutions don’t work, let us know!

Best regards,  
Zach
