There many way you can do that . i will give some options here to import large file using command.

Option 1. You can do this using single cmd. In this cmd D is my xampp or wampp install folder so i use this where mysql.exe install and second option database name and last is sql file so replace it as your then run this. This is for xampp .

D:\xampp\mysql\bin\mysql.exe -u root -p databse_name < D:\yoursqlfile.sql

This is for wampp

D:\wamp64\bin\mysql\mysql5.7.14\bin\mysql.exe -u root -p databse_name< D:\yoursqlfile.sql

just change your folder and mysql version etc

Option 2. Suppose your current path is which is showing command prompt


then change directory using cd.. then goto your mysql directory where your xampp installed. Then cd.. for change directory. then go to bin folder.

C:\xampp\mysql\bin\mysql -u {username} -p {database password}.

then please enter when you see enter password in command prompt.
choose database using

mysql->use test (where database name test)

then put in source sql in bin folder.

then last command will be

mysql-> source test.sql (where test.sql is file name which need to import)

then press enter

This is full command

C:\xampp\mysql\bin\mysql -u {username} -p {database password}
mysql-> use test
mysql->source test.sql