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 <\/p>\n
“Fatal error: Maximum execution time of 300 seconds exceeded with phpMyAdmin”.<\/strong> <\/p>\n 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 If the config-inc.php file is small and\/or missing the above line, the configuration file in the folder <\/p>\n \/usr\/local\/cpanel\/base\/3rdparty\/phpMyAdmin\/libraries\/config.default.php<\/em><\/p>\n is used. The line in config-default.php may look similar to this; Copy this code above and paste it in the config-inc.php and change the execution Time Limit requirement. <\/p>\n 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. <\/p>\n When finished, restart the cPanel service. 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… <\/p>\n
\n
\nvim \/usr\/local\/cpanel\/base\/3rdparty\/phpMyAdmin\/config.inc.php
\n<\/code>
\nand look for this line inside the file;
\n
\n$cfg[\u2019ExecTimeLimit\u2019] = 300;
\n<\/code>
\nand replace with 0 or any larger value. (0 will disable the timeout altogether)
\n
\n$cfg[\u2019ExecTimeLimit\u2019] = 3600;
\n<\/code><\/p>\n
\n
\n\/**
\n* maximum execution time in seconds (0 for no limit)
\n*
\n* @global integer $cfg['ExecTimeLimit']
\n*\/
\n$cfg['ExecTimeLimit'] = 300;
\n<\/code><\/p>\n
\n
\nservice cpanel restart
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"