Fatal error: Maximum execution time of 300 seconds exceeded with phpMyAdmin

Categories General Info

PHPMyAdmin will not work for uploading large mysql databases. If you are working with phpMyAdmin and need to upload a large database you will often get the error

“Fatal error: Maximum execution time of 300 seconds exceeded with phpMyAdmin”.

This is because in the phpMyAdmin configuration there is a setting which causes phpMyAdmin to timeout after a specific timeframe. To eliminate this error you will need to located and edit

vim /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php

and look for this line inside the file;

$cfg[’ExecTimeLimit’] = 300;

and replace with 0 or any larger value. (0 will disable the timeout altogether)

$cfg[’ExecTimeLimit’] = 3600;

If the config-inc.php file is small and/or missing the above line, the configuration file in the folder

/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/config.default.php

is used. The line in config-default.php may look similar to this;

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

Copy this code above and paste it in the config-inc.php and change the execution Time Limit requirement.

If you modify the config.default.php file located in the /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/ folder, the changes will be applied globally for PHPMyAdmin on that server.

When finished, restart the cPanel service.

service cpanel restart

Leave a Reply