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.
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.