phpmyadmin

So, I was importing a large database via PHPmyadmin to my server and as expected I got the irritating message

‘Maximum execution time of 300 seconds exceeded’

At first this seems like a Apache or a PHP timeout error, so I opened my httpd.config and php.ini files and increased the values for script timeouts, but unfortunately the error still continued.

The problem arises because PHPMYADMIN overrides the settings of the server and to resolve this error the configuration file to PhpMyAdmin needs to be edited.

So, look into

/var/www/html/phpMyAdmin-2.6.1/config.inc.php (for linux servers )
or
C:\wamp\apps\phpmyadmin2.11.6\config.inc.php (for windows servers)

NOTE: The paths can vary slightly depending on your configuration.

When you have opened that config file, there is a variable called

$cfg['ExecTimeLimit']

Just change this variable to 0 (for unlimited) or to a sufficiently large number.

Enjoy!