phpmyadmin increase timeout limit [SOLVED]

[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

[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.

[Martin]

Hello,

i would recommend using shell for large imports.

mysql -u USERNAME -p DATABASE < DUMPFILE.sql

[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.

[Tobi]

Large is relatively .

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

[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?

[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.

[select name from me;]

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.

[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.

[Alexander]

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.

[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)

[IchBins]

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

[Alexander]

Take a look:

https://www.hostwinds.com/guide//wp-con ... 47f2d0.gif

[Alexander]

There was a .gif at the time I send my answer, but they changed it .

You can also put the following into the config file /home/keyhelp/www/phpmyadmin/config.inc.php
Changing the time accordingly to your needs.

Code: Select all

ini_set('session.gc_maxlifetime', <TIME>);
$cfg['LoginCookieValidity'] = <TIME>;

However, this config file may be overridden by a KeyHelp update. Do not set this file immutable, as it may break the phpMyAdmin update.

Alternatively use an own instance of phpMyAdmin which you install somewhere on your server an adjust the "Configuration -> Tools -> Database-Administration -> Access URL" to the URL of your phpMyAdmin instance and configure it the way you want.