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
