phpMyAdmin – Fatal error: Maximum execution time (Fix)

Problem Solving 29 November 2010 | 1 Comment

phpMyAdmin has problems when working with large Mysql database imports. If you are getting the following error try following the steps below to fix it.

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

Locate your phpMyAdmin folder and find the file: config.default.php.
I am currently working with XAMPP and the following file can be located: C:\xampp\phpMyAdmin\libraries\config.default.php
Once you have this open in a text editor located this line of code:

$cfg['ExecTimeLimit'] = 300;

and replace it with:

$cfg['ExecTimeLimit'] = 3500;

This will add additional time! Save the file and upload you sql file.

Tagged in , ,

One Response on “phpMyAdmin – Fatal error: Maximum execution time (Fix)”

Trackbacks/Pingbacks

  1. [...] Create a new database and navigate to the import tab. Click Choose File and upload the SQL file you created earlier. Depending on the size of your data base you might have to extend the time limit that is set by default in phpMyAdmin. You can read how to change this here. [...]

Leave a Reply