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

a_smith · 11-12-2013, 10:27 PM

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.

usaafko · 11-13-2013, 04:28 AM

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

a_smith · 11-13-2013, 03:18 PM

To add

Code:

    proxy_send_timeout  600;
    proxy_read_timeout  600;

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

11-12-2013, 10:27 PM	#1
a_smith Junior Member Join Date: Nov 2013 Posts: 4	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.

11-13-2013, 03:18 PM	#3
a_smith Junior Member Join Date: Nov 2013 Posts: 4	To add Code: proxy_send_timeout 600; proxy_read_timeout 600; 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