Here is the little sh script I made to do that. The LOAD DATA INFILE command exists but is not capable of creating the table structure.
#!/bin/sh MYSQL_ARGS="--defaults-file=/etc/mysql/debian.cnf" DB="mbctest" DELIM=";" CSV="$1" TABLE="$2" [ "$CSV" = "" -o "$TABLE" = "" ] && echo "Syntax: $0 csvfile tablename" && exit 1 FIELDS=$(head -1 "$CSV" | sed -e 's/'$DELIM'/` varchar(255),\n`/g' -e 's/\r//g') FIELDS='`'"$FIELDS"'` varchar(255)' #echo "$FIELDS" && exit mysql $MYSQL_ARGS $DB -e " DROP TABLE IF EXISTS $TABLE; CREATE TABLE $TABLE ($FIELDS); LOAD DATA INFILE '$(pwd)/$CSV' INTO TABLE $TABLE FIELDS TERMINATED BY '$DELIM' IGNORE 1 LINES ; "
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
(See comment: “Posted by John Swapceinski on September 5 2011 5:33am”)