Apache Friends Support Forum

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

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?

Thanks, all working now