mysqlimport

on

import data from a csv file into mysql:

mysqlimport --local --fields-enclosed-by='"' --fields-terminated-by=';' --lines-terminated-by='\n'  --columns='col1,col2,col3,col4,col5,col6,col7,col8' -u <user> -p<pwd> <dbname> /home/knilluz/test.csv

let op:
no space between -p and the password (-ppassword)
tablename must be same as filename (without extension).

testing import:

mysql -u <user> -p<password> <database> -e 'select * from test'