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

[ZachE]

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

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

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