Import huge csv to mysql?

hi, I have a huge csv file ( 480mb).phpmyadmin of xampp can import maximum 12mb csv file as mysql db.so how can I import this huge csv as mysql db?

p.s. the ms excel even cant open a 480mb completely

Have MySQL import the file directly. Read the manual page for the LOAD DATA INFILE query.

http://dev.mysql.com/doc/refman/5.0/en/load-data.html

LOAD DATA INFILE can be used to read files obtained from external sources. For example, many programs can export data in comma-separated values (CSV) format, such that lines have fields separated by commas and enclosed within double quotes. If lines in such a file are terminated by newlines, the statement shown here illustrates the field- and line-handling options you would use to load the file:

LOAD DATA INFILE ‘data.txt’ INTO TABLE tbl_name
FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘"’
LINES TERMINATED BY ’
';

done