Time out MYSQL NEED HELP

[vladimirb1]

HI need help w time out in myadmin

[eris]

504 Gateway Timeout

Hi eris, I have these value: # cat /etc/nginx/nginx.conf | grep timeout client_header_timeout 180s; client_body_timeout 180s; send_timeout 60s; keepalive_timeout 30s; fastcgi_connect_timeout 30s; fastcgi_read_timeout 300s; fastcgi_send_timeout 180s; fastcgi_cache_lock_timeout 5s; proxy_connect_timeout 30s; proxy_read_timeout 300s; proxy_se…

[vladimirb1]

what wrong on my config?

[eris]

Check also Apache2 config

[vladimirb1]

some no good here?

[jlguerrero]

To import big files you can do 5 things:

• whenever you see the timeout, hit refresh page. Sometimes it eventually finishes the import without noticeable errors (I don’t like it)
• Increase timeout times (I don’t like it)
• split the database into smaller pieces ( mysqlsplitter gets the job done but it is uncomfortable)
• import with mysqldump via command line ( this is the best method)
• if it is WordPress you can also “sudo -u username wp db import database.sql” ( best method for WP)

[eris]

For a 1mb large it should be no issue

[vladimirb1]

Th…you for help, but my problems from configuratiom. If i use Nginx/fpm-php/Ubuntu 22.04 all good work NO TIME OUT! if change to APACHE+Nginx/fpm-php/Ubuntu 22.04 GET TIME OUT

[jlguerrero]

Then it is a config issue. Do as eris says, change the timeout values

[vladimirb1]

yes, but were config?
prestashop no work too, get server GATEWAY TIME OUT