phpMyAdmin export returns 504 Gateway Time-out

Question

Hello,

When I try to export Database via phpMyadmin, it returns 504 Gateway Time-out after few seconds. 

root@wp-55555:~# sudo log -error

==> /var/log/nginx/22222.error.log <==

2019/02/14 12:43:22 [error] 36331#36331: *1104878 upstream timed out (110: Connection timed out) while reading response header from upstream, client: Client_IP_address_, server: , request: "POST /pma/export.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "139.xx.xx.xx:22222"

2019/02/14 12:44:30 [error] 36331#36331: *1105935 upstream timed out (110: Connection timed out) while reading response header from upstream, client: Client_IP_address_, server: , request: "POST /pma/export.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "139.xx.xx.xx:22222"

What should I modify to make things work?

Thanks

Comments

This user was BANNED: Fake email account.

Answer 1

Hi Edwin,

Try increasing fastcgi_read_timeout value, if it doesn't work you can play with the send_timeout value and also I'm not sure, but maybe keepalive_timeout value too.

Don't forget restart nginx service to changes can take effect.