How to solve time out in phpmyadmin?

If even after repeated upload you still get timeout error, pleasechange your settings in

\phpmyadmin\libraries\config.default.php

from $cfg['ExecTimeLimit'] = 300; to $cfg['ExecTimeLimit'] = 0; and restart. Now there is no execution time limit (trust we are talking about local server).

Source : Change Script time out in phpmyadmin

I had the same issue and I used command line in order to import the SQL file. This method has 3 advantages:

1. It is a very easy way by running only 1 command line
2. It runs way faster
3. It does not have limitation

If you want to do this just follow this 3 steps:

1. Navigate to this path (i use wamp):

   C:\wamp\bin\mysql\mysql5.6.17\bin>

2. Copy your sql file inside this path (ex file.sql)

3. Run this command:

   mysql -u username -p database_name < file.sql

^{Note: if you already have your msql enviroment variable path set, you don't need to move your file.sql in the bin directory and you should only navigate to the path of the file.}

I'm using version 4.0.3 of MAMP along with phpmyadmin. The top of /Applications/MAMP/bin/phpMyAdmin/libraries/config.default.php reads:

DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!

Changing the following line in /Applications/MAMP/bin/phpMyAdmin/config.inc.php and restarting MAMP worked for me.

$cfg['ExecTimeLimit'] = 0;