mysql import sql file

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

1mysql -u username -p database_name < file.sql
2; OR
3 mysql> use db_name;
4 mysql> source file_name.sql;

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

1mysql>create database yourDatabaseName;
2mysql>use yourDatabaseName;

1zcat /path/to/file.sql.gz | mysql -u 'root' -p your_database