How to Solve Time Out in PHPmyadmin

How to set my phpmyadmin user session to not time out so quickly?

To increase the phpMyAdmin Session Timeout, open config.inc.php in the root phpMyAdmin directory and add this setting (anywhere).

$cfg['LoginCookieValidity'] = <your_new_timeout>;

Where <your_new_timeout> is some number larger than 1800.

Note:

Always keep on mind that a short cookie lifetime is all well and good for the development server. So do not do this on your production server.

Script timeout passed, if you want to finish import, please resubmit the same file and import will resume

If you are importing your database using Phpmyadmin, then there's a configuration file for it. The default/example config file is found here:

\phpmyadmin\libraries\config.default.php

Don't edit this file as it may get overwritten in future updates. Instead look for an existing file here:

\phpmyadmin\config.inc.php

...and if it does not exist, create it.

Open this configuration file in any editor and change $cfg['ExecTimeLimit'] = 300; to $cfg['ExecTimeLimit'] = 0;

(or if it does not exist, add it)

Restart your localhost, now you don't have any time limit.

Or you can use MySQL command line to import your unzipped SQL file directly, something like below:

mysql -u username -p database_name < my_unzipped_import_file.sql

Script timeout passed error on MAMP phpmyadmin

I think You need to change the execution time limit in config.default.php as following:

$cfg['ExecTimeLimit'] = 3600; // whatever time you want to put as execution time

As the script is running out of time so you should have to increase its execution time in MAMP and restart.

phpMyAdmin timeout not respecting PHP.ini max_execution_time

I am unsure if this is an adequate solution for someone encountering the same problem but my workaround was to split the large SQL file into smaller files using SQL Dump File Splitter

Maximum execution time in phpMyadmin

I have the same error, please go to

xampp\phpMyAdmin\libraries\config.default.php

Look for : $cfg['ExecTimeLimit'] = 600;

You can change '600' to any higher value, like '6000'.

Maximum execution time in seconds is (0 for no limit).

This will fix your error.

Timeout error occurs while import file sql into phpmyadmin on cpanel server

PHPMyAdmin does not rely on the timeout or memory limit set in cPanel and takes its values from the server default timeout specified in WHM. So if you need it increased, it can be increased via WHM >> Tweak Settings >> cPanel PHP max execution time (its default is 90 sec and you need root access to modify it.)

As the database size seems large as it is of a Magento website, I suggest you to try doing the 1st method (source using shell)

Do you have shell access. If yes, log in to the user account as the cPanel user.Issue the following command
mysql -u username -p

Enter the password when prompted and then enter the command
use database_name;

replace database_name with the actual database name.

Now import the database by issuing the command

source /your/path/to/backup.sql;

where /your/path/to/backup.sql is the actual path to backup file.

If this is not available, contact your hosting provider with the backup file and they should be able to source it for you.
If you need the import to be done via cPanel provided PHPMyAdmin itself, then you need to increase the timeout specified in the beginning.
Import the backup as chunks but it is more complex.