Import huge mysql db in XAMPP and Mysql shell

First go to the location of mysql file in command prompt

 

Cd c:\xampp\mysql\bin

 

Copy the required .sql file inside temp inside the bin folder

 

mysql -u username -p newdatabase_name < oldfile.sql