How to Import Database using command prompt

Import Database in WAMP:

mysql -u username -p database_name <  your_sql_file.sql

Import Database in XAMPP:

D:\xampp\mysql\bin\mysql.exe -u root -p db_name < D:\your_sql_file.sql

Read More