Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours on Instagram and YouTube and waste money on coffee and fast food, but won’t spend 30 minutes a day learning skills to boost our careers.
Master in DevOps, SRE, DevSecOps & MLOps!

Learn from Guru Rajesh Kumar and double your salary in just one year.

Get Started Now!

Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\classes\Dbi\DbiMysqli.php on line 199

In this tutorial I’m going to solve this error Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\classes\Dbi\DbiMysqli.php on line 199.

Whenever you import file in in database then after some processing time its show you have using Maximum execution time of 300 seconds exceeded will be showing this type of error in your database:

Step 1 : Stop your Xampp Server

Step 2: go to config.default.php

Once that’s done get back to finding phpMyadmin config file named something like “config.default.php”. On XAMPP you will find it under “C:\xampp\phpMyAdmin\libraries” folder. Open the file called config.default.php and set :

$cfg['ExecTimeLimit'] = 0;

Once set, restart your MySQL and Apache and go import your database.

Related Posts

How to Install and Enable GMP Extension in XAMPP PHP on Linux (Step-by-Step Guide)

Introduction If you are using XAMPP PHP on a Linux server and encounter errors like: then this usually means the GMP extension is not installed, not just Read More

Read More

Error : MySQL shutdown unexpectedly. This may be due to a blocked port, missing dependencies , improper privileges, a crash, or a shutdown by another method.

Step 1: First, stop Apache and MySQL in the XAMPP server, then go to C:\xampp\mysql and back up the data folder. Step 2: After backing up the Read More

Read More

You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit.

For Upload large size data in using phpmyadmin Do following steps. than after restart wamp server or restart all services Now Upload data using import function in Read More

Read More

phpMyAdmin Troubleshooting Advance Guides

Here are some advanced troubleshooting guides for PHPMyAdmin: 1. Performance Issues Slow Loading Times: 2. Connection Issues Error Messages like “Access Denied for User”: 3. Session Timeout Read More

Read More

ERROR 1153 (08S01) at line 1582: Got a packet bigger than ‘max_allowed_packet’ bytes

When I’m trying to add a big file to my WordPress phpmyadmin database, I keep getting errors like this:- ERROR 1153 (08S01) at line 1582: Got a Read More

Read More

Setting Up Virtual Hosts in XAMPP for Windows: A Step-by-Step Guide

To create a virtual host in XAMPP, you need to follow these steps: 2. Configure Apache: 3. Restart Apache: 4. Access Your Virtual Host: Make sure that Read More

Read More
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x