The Personal Weblog of Akshay Jain
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!
I am Akshay Jain a student in Economics and a web enthusiast. Most of my readers would be knowing me by my pseudonym champ_rock/champrock. This is my blog and I know I wont be keeping this updated. For contacting me, please use the contact form!
Please subscribe to the RSS feeds in order to get the latest updates on my blog!
WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.
Designo
November 13th, 2008 at 1:36 pm
Thanx a lot!
You were the only one providing a “straight” solution”
pkiff
November 28th, 2008 at 5:22 pm
FYI:
http://drupal.org/node/279344#comment-1130077