It can happen that the following error message is displayed when importing a database via phpMyAdmin:
Fatal error: Maximum execution time of 60 seconds exceeded in xampp\phpmyadmin\libraries\dbi\mysql.dbi.lib.php on line 140
As you can see from the error message, the maximum execution time of 60 seconds has been exceeded. This often happens with particularly large databases. To import the database nevertheless, you need to manually increase the execution time.
To do this, open the following path:
xampp\phpMyAdmin\libraries\config.default.php
In the config.default.php file, change the value of the following line or add the line if it does not already exist:
$cfg['ExecTimeLimit'] = 600;
For example, change it to:
$cfg['ExecTimeLimit'] = 7200;
This may be sufficient to resolve the error.
If the error persists, you also need to open:
xampp\php\php.ini
and add the following lines or increase their values to the ones suggested by us:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit =1000M
In addition, you should open:
xampp\mysql\bin\my.ini
and adjust the following line to the value specified here (as an example):
max_allowed_packet = 200M
Important: For these changes to take effect, you need to restart both the Apache server and the database (SQL) service.
