XAMPP - MySQL Load Table with 8000 rows, 1.16 GB

The back up .SQL file seems to be excessively large at 1.16GB, but nevertheless I would like to load it locally on my laptop running the XAMPP server

First I alter the php.ini file so that the back up SQL file can be uploaded through XAMPP's PHPMyAdmin.

Also had to overcome a time limit constraint by editing C:\xampp\phpMyAdmin\config.inc.php with $cfg['ExecTimeLimit'] = 0;

Lastly use the command line to override mySQL settings.

After loading the table, reset mySQL settings

---

Perhaps rather than all this, maybe I should create and load the table with a batch program outside of PHPMyAdmin.