mysql import from sql file

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

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

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

1LOAD DATA INFILE "name.csv" INTO TABLE "TableName"
2FIELDS TERMINATED BY "sign"
3LINES TERMINATED BY "sign"
4IGNORE 1 LINES
5(columns);