I was working with Google API and I need to implement World’s City and its population in Google Map. For that, I downloaded world’s city and its population database and trying to import it into my local phpmyadmin. Database is with size of 33MB and when I try to import it via Import function, it throws me Fatal error: Maximum execution time of 300 seconds exceeded in \xampp\phpMyAdmin\libraries\import\sql.php on line 133 error.
To get rid of this error, we need to make a change in phpmyadmin config file and increase the execution time. If you had the same issue than go to xampp/phpmyadmin and open config.inc.php file. Copy the below line and put it into config.inc.php file.
$cfg['ExecTimeLimit'] = 3600;
This solves your problems of maximum execution time reached, max_execution_time phpmyadmin, Fatal error: Maximum execution time of 300 seconds exceeded, Increase maximum execution time of phpmyadmin, import big database via phpmyadmin, how to increase import execution time, mysql import large database, mysql import increase execution time.