502 Bad Gateway Error when exporting database

[netsetter]

Hi, it's there again since a while: 502 Bad Gateway error when exporting a database.

Happens by random, but mostly when I switch the database, having a database open in PHPmyAdmin, then I close this tab and open another database from the plesk menu. Then trying to export --> error.

CentOS 6.4, PHP 5.3, Plesk 11.5 #MU13

 

[IgorG]

Try solution from this thread - http://forum.parallels.com/showthread.php?261367

 

[IgorG]

Fixed in 11.5.30 MU#14

 

[Silvester Leer]

Fixed in 11.5.30 MU#14

Still getting bad gateway errors.

 

[Cike76]

In some cases the database is real big and takes time the dump, thus generating the bad gateway problem.
Why dont you make the backup on command line?
The command goes like this...

mysqldump -u[user_database] -p [database] > [backup_filename].sql

Ommit the "[" and "]" characters, I put them for you to bettter understand the command
Once you hit enter it will ask for the user database passwd

 

[Peter-]

I updated to 11.5.30 MU#16 and still getting errors, even if the database is empty. Why isn't anyone looking into it? Command line obviously isn't a solution since you pay for a software to use it

 

[netsetter]

I can confirm, error still exists in MU#18.

@Peter: They tried to fix this error almost every time it was reported, but it seems it's more complex in some way.

I don't know if it somehow helps or if it's related to this Bad Gateway error, but also sometimes when I am deleting data by selecting rows and hitting the delete button, I am getting a blank screen in the right column of PHPMyAdmin.

 

[netsetter]

Okay, a bit more detailed:

When I am in PHPMyAdmin in localhost:3306, hitting export button and selecting the database in the advanced options, exporting works.
But when I am in localhost:3306 » myselected_database, hitting export button and selecting all the tables to export, then I have this 502 Bad Gateway error.

 

[netsetter]

Any news about working on a fix for the next plesk update?

 

[Peter-]

Hey

This worked for me (at least so far ):

nano /etc/sw-cp-server/config

fastcgi_buffers 32 32k; // was 16 16k
fastcgi_buffer_size 64k; // was 32k

#yum reinstall tzdata // I had to remove timezone info because dumb plesk wouldn't let me login at all after restarting You may not need that

service psa restart

nano /usr/local/psa/admin/conf/php.ini
apc.enabled = 1
apc.filters = "-.*phpMyAdmin*"

service sw-engine restart

--

 

[netsetter]

apc.filters = "-.*phpMyAdmin*"

Thanks a lot Peter, this line made it working!

 

[MislavO]

Or maybe this:

Could not export database using PHPMyAdmin: "Nginx 502 Bad Gateway"
http://kb.parallels.com/en/117480