Phpmyadmin import sql_db.zip error

[carlesrub]

Hello,
I am new to hestiacp and I am trying to use it.
I try to import and mysql_db_backup.zip 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

[eris]

Increase the timeouts between Nginx + Apache2

[Raphael]

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

[carlesrub]

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.

[eris]

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

to 60 or 180

The file is located in /etc/apache2/

[carlesrub]

Thanks, I try

[carlesrub]

It worked perfectly, thank you very much Eris

[carlesrub]

Thanks SciT, the problem has already been fixed.

[jlguerrero]

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.

[Raphael]

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

[carlesrub]

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

[jlguerrero]

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 https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar && 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 (cliente.com) and install wordpress via the HestiaCP interface
Enable BASH access for that user.

We copy the database and wp-config.zip 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/cliente.com/public_html
Unzip wp content zipfile
unzip -qqo wp_content.zip

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 cliente.com_db_20210502.sql.zip

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

Tweaks

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