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

[alisukhera]

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

[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