nginx “504 Gateway Time-out” on phpMyadmin dump upload
 

Hello all

I have problem with phpmyadmin. When I try to upload bigger sql dump (30MB) after about 1 minute I get white page and nginx “504 Gateway Time-out” error message.

(max file size/max post size/memory limit - all set up in Apache and PHP. No problem there).

Also I have quite long script times setup in Apache, nginx and PHP but it didn't work.

And I stack.... I am using FCGI for all domains but FCGI its runing with default setup

Please help some. Thanks.

Hello, you need to change timeouts in your FCGI processor (and I advice you to use mysqldump and mysql utilities)

To add

to /etc/nginx/ngix.conf solved the problem.

After having the system setup right phpmyadmi dump import option works like a charm and I never had any issue with it (even with almost 300MB dump). So personaly I dont see any reason for using external tools.
Thanks