How to import the sql file in mysql using command line

Microsoft Windows [Version 10.0.22000.675]

(c) Microsoft Corporation. All rights reserved.

C:\Users\PC\Downloads>mysql -u root -p Databasename < databasefile.sql 
'mysql' is not recognized as an internal or external command, operable program, or batch file.

Solution: Simply type in the command prompt :

C:\Users\PC\Downloads>set path=%PATH%;C:\xampp\mysql\bin;

C:\Users\PC\Downloads>mysql -u root -p Databasename < databasefile.sql Enter password:

C:\Users\PC\Downloads>
 

Database Successfully import