To Import sql file through command line

To import sql file through command line

open command line and type "cd .." and enter upto C:\> after that

C:\>cd xampp/mysql/bin

C:\xampp\mysql\bin>mysql -u root -p dbname < "Drag and drop the sql file"