I've been trying to import fields that contains the comma character ','
inside double quotes '"', with the results following:

<code>

mysqlimport --fields-optionally-enclosed-by=""" --fields-terminated-by=,
--lines-terminated-by="\r\n" --ignore-lines=1 --user=root --password shark
"c:\documents and settings\shamm\desktop\result.csv"

Enter password: **********

mysqlimport: Error: Row 48 was truncated; it contained more data than there
were input columns, when using table: result


Line 48:

"48", "14.729606", "10.1.1.22", "10.182.167.209", "TCP", "pop3 > 1111 [SYN,
ACK] Seq=0 Ack=1 Win=16384 Len=0 MSS=1460"



mysql> desc result;
+-------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+-------+
| No | int(10) unsigned | NO | | | |
| Time | text | NO | | | |
| Source | text | NO | | | |
| Destination | text | NO | | | |
| Protocol | text | NO | | | |
| Info | text | NO | | | |
+-------------+------------------+------+-----+---------+-------+
6 rows in set (0.03 sec)

C:\Documents and Settings\shamm>mysql --version
mysql Ver 14.12 Distrib 5.0.26, for Win32 (ia32)

</code>

--
--------------------------------------------------------------------
`Twas brillig, and the slithy toves
Did gyre and gimble in the wabe:
All mimsy were the borogoves,
And the mome raths outgrabe.
--------------------------------------------------------------------