XAMPP sets the my.ini DB resource usage settings too low. ie specs for computers that existed in the 1990’s. Update the my.ini settings in this file: /xampp/mysql/bin/my.ini to the settings shown below. A 14MB database import took 3 hours before changing the default XAMPP my.ini settings. After changing the my.ini settings to the settings shown below > the same 14MB database import took 3 minutes. Restart Apache and MySQL after changing your my.ini setting.
Important Note: My computer has 16GB of RAM. So I set the innodb_buffer_pool_size setting to 50% of my RAM = 8G
innodb_buffer_pool_size=8G
innodb_log_buffer_size=500M
innodb_log_file_size=1G
innodb_flush_log_at_trx_commit=0
.
