LOAD DATA INFILE '/tmp/datafile' INTO TABLE data FIELDS TERMINATED BY ' ' (@srcip, @dstip, bytes, packets, srcuser, dstuser) SET srcip=INET_ATON(@srcip), dstip=INET_ATON(@dstip);