phpmyadmin increase timeout limit  [SOLVED]

Zoltan
Posts: 9
Joined: Mon 6. Apr 2020, 11:23

phpmyadmin increase timeout limit

Post by Zoltan »

Hello,

I've an sql file which is always failed to import because of phpmyadmin timeout.
How to increase timeout in phpmyadmin? I really can't find phpmyadmin config file on debian server.

thank you

Zoltan
User avatar
Tobi
Community Moderator
Posts: 2813
Joined: Thu 5. Jan 2017, 13:24

Re: phpmyadmin increase timeout limit

Post by Tobi »

Phpmyadmin ist not the first choice for large SQL-imports.

Better try bigdump.
https://www.ozerov.de/bigdump/

This one works perfectly with huge imports.
Gruß,
Tobi


-----------------------------
wewoco.de
Das Forum für Reseller, Digital-Agenturen, Bildschirmarbeiter und Mäuseschubser
User avatar
Martin
Posts: 984
Joined: Wed 20. Jan 2016, 00:43

Re: phpmyadmin increase timeout limit

Post by Martin »

Hello,

i would recommend using shell for large imports.

mysql -u USERNAME -p DATABASE < DUMPFILE.sql
Viele Grüße,
Martin
Zoltan
Posts: 9
Joined: Mon 6. Apr 2020, 11:23

Re: phpmyadmin increase timeout limit

Post by Zoltan »

This import is not really "large". File size without compression is only 32MB
The VPS itself not the strongest but enough powerful for this "small/large" database: has 2cpu cores and 2GB RAM, no any other website or task running on it.
That is why I try to increase timeout. I think +30 seconds will be more than enough.

Edit: anyway I receive 504 gateway timeout at phpmyadmin import.
User avatar
Tobi
Community Moderator
Posts: 2813
Joined: Thu 5. Jan 2017, 13:24

Re: phpmyadmin increase timeout limit

Post by Tobi »

Large is relatively 😂.

Anyway, it will work on command line as Martin suggested or with the script I linked.
Gruß,
Tobi


-----------------------------
wewoco.de
Das Forum für Reseller, Digital-Agenturen, Bildschirmarbeiter und Mäuseschubser
Zoltan
Posts: 9
Joined: Mon 6. Apr 2020, 11:23

Re: phpmyadmin increase timeout limit

Post by Zoltan »

Okay, but the problem is my costumer has no any idea about how to use ssh...
So made this question out of this problem.
How to increase phpmyadmin time limits just for fun? :)
User avatar
Martin
Posts: 984
Joined: Wed 20. Jan 2016, 00:43

Re: phpmyadmin increase timeout limit

Post by Martin »

Hello,

the phpmyadmin values comes from the KeyHelp FPM Pool itself. These can be found within /etc/php/7.2/fpm/pool.d/keyhelp.conf

After changes, php7.2-fpm service needs to be restarted.
Viele Grüße,
Martin
select name from me;
Posts: 579
Joined: Tue 9. Feb 2016, 16:44

Re: phpmyadmin increase timeout limit

Post by select name from me; »

Zoltan wrote: Wed 8. Apr 2020, 11:33 I've an sql file which is always failed to import because of phpmyadmin timeout.
How to increase timeout in phpmyadmin? I really can't find phpmyadmin config file on debian server.
Sometimes it works, if you prepend this line (start of the file) ...

Code: Select all

SET AUTOCOMMIT = 0;SET FOREIGN_KEY_CHECKS=0;
... and append this line (end of the file) ...

Code: Select all

SET FOREIGN_KEY_CHECKS = 1;COMMIT; SET AUTOCOMMIT = 1;
... to your sql dump. The import will be much faster.
Viele Grüße, Christian
User avatar
Szektor
Posts: 10
Joined: Mon 17. May 2021, 23:35
Location: Budapest
Contact:

Re: phpmyadmin increase timeout limit

Post by Szektor »

Martin wrote: Wed 8. Apr 2020, 17:30 Hello,

the phpmyadmin values comes from the KeyHelp FPM Pool itself. These can be found within /etc/php/7.2/fpm/pool.d/keyhelp.conf

After changes, php7.2-fpm service needs to be restarted.
Thanks. I found some php_admin_value parameters here but there is no default setting for timeout.
How can we add one here properly?
User avatar
Florian
Keyweb AG
Posts: 1243
Joined: Wed 20. Jan 2016, 02:28

Re: phpmyadmin increase timeout limit

Post by Florian »

Hallo,

the first time related setting is the max_execution _time in the PHP-FPM Pool

The second one is the PHP-FPM timeout in /etc/apache2/keyhelp/keyhelp.conf

Code: Select all

<Proxy fcgi://keyhelp_keyhelp.socket>
        ProxySet connectiontimeout=5 timeout=120
    </Proxy>
Changes have to be done in both places. But they will be changed back with the next Keyhelp Update.
Mit freundlichen Grüßen / Best regards
Florian Cheno

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
User avatar
Szektor
Posts: 10
Joined: Mon 17. May 2021, 23:35
Location: Budapest
Contact:

Re: phpmyadmin increase timeout limit

Post by Szektor »

In this case is that possible to increase these limits by default?
I guess it wouldn't be a serious security concern to raise this to 60 minutes.
Also increasing execution time and file sizes + memory limits for phpMyadmin would be great.
I guess I am not the only one that have clients completely unaware of ssh.
This could be a huge time saving for all of us.
User avatar
Alexander
Keyweb AG
Posts: 3813
Joined: Wed 20. Jan 2016, 02:23

Re: phpmyadmin increase timeout limit

Post by Alexander »

Szektor wrote: Fri 21. May 2021, 16:30 I guess it wouldn't be a serious security concern to raise this to 60 minutes.
If you think these values are fine, than sure, adjust them as you like, but i would argue that the majority of admins would not increase this setting up to 60 minutes. But hey, everybody can edit the mentioned config files as he/she like ;).

But they will be changed back with the next Keyhelp Update.
This is not necessarily be the case. So changing the values in the files will be fine and will remain after KeyHelp updates.
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
User avatar
Szektor
Posts: 10
Joined: Mon 17. May 2021, 23:35
Location: Budapest
Contact:

Re: phpmyadmin increase timeout limit

Post by Szektor »

Ok, thanks for these.
So I change:
1, /etc/php/7.2/fpm/pool.d/keyhelp.conf
2, /etc/apache2/keyhelp/keyhelp.conf
3, Now I am only missing a value for phpmyadmin admin timeout. I would increase that from 20 minutes to 60.
How can I add a php_admin_value for that? Since there is no default value for that.
(I guess there must be a naming for it but I might be wrong.)
User avatar
Alexander
Keyweb AG
Posts: 3813
Joined: Wed 20. Jan 2016, 02:23

Re: phpmyadmin increase timeout limit

Post by Alexander »

Like Florian already told you, the value is called "max_execution_time".

There is no timeout value solely for phpMyAdmin, this is not how PHP works.

"max_execution_time" is a general value for all vhosts using this particular PHP-FPM pool file, which are:
- KeyHelp
- KeyHelp webmail tools (Roundcube / Rainloop)
- KeyHelp database administration tools (phpMyAdmin / Adminer)
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
IchBins
Posts: 112
Joined: Thu 19. Nov 2020, 15:07

Re: phpmyadmin increase timeout limit

Post by IchBins »

Vielleicht hilft viewtopic.php?f=5&t=10149 weiter.
Locked