[How to solve] – Fatal error : Maximum execution time of 300 seconds exceeded

Sometimes when we want to learn a source code to the database we are given an SQL dump to be studied again. Some time ago, I was studying the structure of the data from MySQL given by my friend. However I find this error message when I try to import them to my device.  “Fatal error : Maximum execution time of 300 seconds exceeded” . as seen in the picture. Happen to my office devices using windows.

Maximum-execution-time-of-300-seconds-exceeded

After I trace the error message, I know why it happened. and it turns out the default PHPMyAdmin configuration. And then open this file xampp\phpmyadmin\config.inc.php . Search line code and set value :

$cfg['ExecTimeLimit'] = 6000;

And then open this file xampp\php\php.ini . Search line code and set value this according to the needs.

post_max_size = 128M
upload_max_filesize = 128M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 128M

And then open this file xampp\mysql\bin\my.ini . Search line code and set value this according to the needs.

max_allowed_packet = 200M

Do not forget to save all configurations. Please restart the web server and the database server.  You can tried to import data SQL. If there are criticisms and suggestions, or a more serious problem on this matter, you can tell me. I hope be useful.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s