Phpmyadmin import error

I am new to hestiacp and I am trying to use it.
I try to import and with 1.8 MiB and the phpmyadmin returns this error code:
504 Gateway Timeout “The gateway did not receive a timely response from the upstream server or application”
How can I solve this error?

Thanks in advance :wink:

Increase the timeouts between Nginx + Apache2

or use the cli command to restore the sql file :).

1 Like

Hummm, Thanks I increased to 60s the parameter “pm.process_idle_timeout” in file "/etc/php/7.4/fpm/pool.d/www.conf " and I restart the services apache2 and nginx but the error remains.

Change this hestiacp/apache2.conf at 47cf4a076776c225d686b08c7aab94234d76c535 · hestiacp/hestiacp · GitHub

to 60 or 180

The file is located in /etc/apache2/

1 Like

Thanks, I try :wink:

It worked perfectly, thank you very much Eris :wink:

Thanks SciT, the problem has already been fixed.

The command line is by far sadly the best method.

As for the phpmyadmin 504 error. Hit reload once or twice. Sometimes it finishes the task.

I would not call it sadly, its the most direct and professional one :).

1 Like

Hi ScIT ,
For the next database that I have to import in format, could you tell me the command to do it. Thanks

Taken from my company’s internal manuals.

I suppose you want to migrate a wordpress.

Dependencies: WP CLI

Login as root

Install WP CLI with this one-line command
curl -O && chmod +x wp-cli.phar && sudo mv wp-cli.phar /usr/local/bin/wp && wp cli update

Optional: Enable wp rewrite flush command

echo "apache_modules:" >> ~/.wp-cli/config.yml
echo " - mod_rewrite" >> ~/.wp-cli/config.yml

Create web space

Create a new user, domain ( and install wordpress via the HestiaCP interface
Enable BASH access for that user.

We copy the database and to the public_html folder

With WinSCP or the file manager, rsync, scp or we download it via wget…

SSH login with the unprivileged user that you just created for the domain

Change to the target directory
cd web/
Unzip wp content zipfile
unzip -qqo

Optional: Destroy and restore database

Destroy wordpress database (for the default install)
wp db drop

Create a new wordpress database with the info provided in wp-config.php
wp db create

Import Database

If the database is compressed:
unzip -qqo

We import the database with this command:
wp db import cliente.com_db_20210502.sql

If it fails, or if it is NOT WORDPRESS you may try this command: mysqldump -u mysql_user -p database < file.sql

mysqldump -u cliente.com_82925 -p cliente.com_82925 < cliente.com_db_20210502.sql


wp search-replace http:// https://
Please dont forget the “//” or you may transform https into httpss and break the urls.

Permalink refresh

wp rewrite flush --hard

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.