Go to xampp/phpMyAdmin/libraries/config.default.php find $cfg['ExecTimeLimit'] = 300; line no 695 and replace $cfg['ExecTimeLimit'] = 0;

Instead of XAMPP you may use LAMP(Linux Apache MySQL PHP) mostly. Using LAMP you may also face this problem.

In my case(using Ubuntu 15.10), I had configured/set post_max_size, upload_max_filesize, max_execution_time, max_input_time, memory_limit following my needs using php.ini file which is located at /etc/php5/apache2/php.ini

But still I was faced this problem. Then solved the problem using config.default.php file, where you can find out like this line below:

$cfg['ExecTimeLimit'] = 300; Make it to

$cfg['ExecTimeLimit'] = 0;

Note: You can locate config.default.php file via your terminal(Ctrl+Alt+T) by this commandlocate config.default.php possible path is /usr/share/phpmyadmin/libraries/config.default.php

Xampp in Ubuntu

If you are importing your database using PhpMyAdmin, then there's a configuration file for it:

/opt/lampp/phpmyadmin/libraries/config.default.php

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

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

You need to change

$cfg['ExecTimeLimit'] = 300;

to

$cfg['ExecTimeLimit'] = 0;

in your config.php file located by default in \phpmyadmin\libraries\config.default.php

Restart your localhost.

It will definitely work. Enjoy.

WampServer Version 3 - Windows

Open config.default.php

You can find it here

C:\wamp\apps\phpmyadmin\libraries\config.default.php

Search for ExecTimeLimit

/**
 * maximum execution time in seconds (0 for no limit)
 *
 * @global integer $cfg['ExecTimeLimit']
 */
$cfg['ExecTimeLimit'] = 300;

increase the value of $cfg['ExecTimeLimit'] or set it to 0 for no limit

in

config.inc.php

add this

$cfg['ExecTimeLimit'] = 0;

for me is work

MAC OS MAMP

edit this file

/Applications/MAMP/./bin/phpMyAdmin/config.inc.php

and dont forget restart MAMP

for lamp ubuntu :- first go to config.default.php location you can find by execute

locate config.default.php

in my case its locate at /usr/share/phpmyadmin/libraries

cd /usr/share/phpmyadmin/libraries

now edit config.default.php file in my case i use gedit you can install by

sudo apt install gedit

sudo gedit config.default.php

no search for ExecTimeLimit in file change $cfg['ExecTimeLimit'] = 300; to

$cfg['ExecTimeLimit'] = 0; 

save and close it, restart server by

sudo service apache2 restart

This way will work with Windows OS + WAMP server

You can directly import .sql file via MySQL server by calling it from your CMD at this path C:\wamp64\bin\mysql\mysql{version}\bin

1- Open your CMD
2- cd C:\wamp64\bin\mysql\mysql{version}\bin
3- mysql -u root -p < {/path/to/your/sql/file/.sql}

This way didn't have a limitation on execution time compared to phpMyAdmin.

If you are importing your database using Phpmyadmin, then there's a configuration file for it: \phpmyadmin\libraries\config.default.php

The way it is described in the accepted answer by @Tejashwi Kalp Taru has it's flaws.

@Gibran Dimasagung mentioned the correct way, by editing

config.inc.php

as the header of the config.default.php file cleary states following:

DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! phpMyAdmin default configuration, you can copy values from here to your config.inc.php

It's likely that all changes applied to config.default.php will be lost after an update.