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'