Jan 212010
 

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

 Posted by at 4:29 am