Timeout error on import

[ibaker]

Hi, I have Xampp installed using the PHP 7.4 version on windows 10 pc.

Using phpMyAdmin I am trying to import an sql file of 660mb in size.

I have made these changes to the .ini files:
The xampp/php/php.ini file as follows:
memory_limit = 1024M
post_max_size = 1024M
upload_max_filesize = 1024M

Also, the xampp/mysql/bin/my.ini file as follows:
[mysqld]
max_allowed_packet = 1024M
[mysqldump]
max_allowed_packet = 1024M

Lastly I changed this
1. Open file \phpmyadmin\libraries\config.default.php
2. Change the variable
$cfg['ExecTimeLimit'] = 300;
to
$cfg['ExecTimeLimit'] = 0;

However i end up getting a timeout error:
Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\vendor\phpmyadmin\sql-parser\src\Token.php on line 204

Can anyone help me with this...thanks

[Froosh]

The change you made to config.default.php should really be done in \phpMyAdmin\config.inc.php.
Also, did you by any chance try restarting Apache after making the configuration changes?

[ibaker]

Thanks, all working now