If the import is to be done via cPanel provided PHPMyAdmin itself, then we need to increase the timeout. To do so, go to, WHM >> Tweak Settings >> cPanel PHP max execution time.
PHPMyAdmin is able to handle unlimited amount of data when it comes to exporting a table to sql, csv or spreadsheets.
Go to PHPMyAdmin in your browser
Settings > Features > Change the value of Login cookie validity > Save
NOTE: You will have to do this per session.
Add this line to /config.inc.php:
$cfg['LoginCookieValidity'] = 36000;
In /setup/lib/index.lib.php
$cf->getValue('LoginCookieValidity') > 36000;
If you don't already have a .htaccess file for your phpMyAdmin site, create one, and add the following line to override the default PHP session timeout:
php_value session.gc_maxlifetime 36000
I would not recommend altering this value in your main php.ini file, as it will allow a ridiculously long session timeout for all your PHP sites.
source: http://www.sitekickr.com/blog/increase-phpmyadmin-timeout/
We can change the cookie time session feature at:
Settings->Features->General->Login cookie validity
I found the answer in here.. No activity within 1440 seconds; please log in again
EDIT:
This solution will work only for the current session, to change permanently do:
open config.inc.php in the root phpMyAdmin directory .
wamp folder: wamp\apps\phpmyadmin{version}\config.inc.php
ubuntu: /etc/phpmyadmin
add this line
$cfg['LoginCookieValidity'] = <your_timeout>;
Example
$cfg['LoginCookieValidity'] = '144000';
You can change the cookie time session feature at phpmyadmin web interface
Settings->Features->General->Login cookie validity
OR
If you want to change the 'login cookie validity' in configuration file, then open the phpmMyAdmin configuration file, config.inc.php
in the root directory of PHPMyAdmin.(root directory is usually /etc/phpmyadmin/)
After locating the config.inc.php , search for the line below and set it to the value of seconds you want phpmyadmin to timeout:
$cfg['LoginCookieValidity']
or
Add the following:
$cfg[ ' Servers'] [$i] [ ' LoginCookieValidity' ] = <your_new_timeout>;
For example:
$cfg[ ' Servers'] [$i] [ ' LoginCookieValidity' ] = <3600 * 3 >;
The Timeout is set to 3 Hours from the Example above.
session.gc_maxlifetime
might limit session validity and if the session is lost, the login cookie is also invalidated. So, we may need to set the session.gc_maxlifetime in php.ini
configuration file(file location is /etc/php5 /apache2/php.ini in ubuntu).
session.gc_maxlifetime = 3600 * 3
$cfg['LoginCookieValidity']
Type: integer [number of seconds]
Default value: 1440
Define how long a login cookie is valid. Please note that php configuration option session.gc_maxlifetime might limit session validity and if the session is lost, the login cookie is also invalidated. So it is a good idea to set session.gc_maxlifetime at least to the same value of $cfg['LoginCookieValidity'].
NOTE:
PHP Fatal
error: Call to a member function get() on a non-object in
/path/to/phpmyadmin/libraries/Header.class.php
on line 135, then do
a chmod 644 config.inc.php
. that should take care of the error.Your PHP parameter
session.gc_maxlifetime is lower that cookie validity configured in
phpMyAdmin, because of this, your login will expire sooner than
configured in phpMyAdmin.
. then change the session.gc_maxlifetime
as mentioned above.If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With