import database mysql command line

1# if your database is not locally hosted
2mysql -u username -p -h dbhost dbname < filename.sql

1mysql -u username -p database_name < file.sql

1mysql -u username -p database_name < file.sql
2

1mysql -u username -p new_database < data-dump.sql
2

1 mysql> use db_name;
2 mysql> source file_name.sql;

1Source : https://www.programmingquest.com/2018/08/how-to-export-mysql-database-using.html
2open cmd
3set mysql path in cmd
4	set path=c:\wamp\bin\mysql\mysql5.6.17\bin
5For database import (Restore): 
6	mysql -u YourUser -p YourDatabaseName < filename.sql