in reply to Parse a .txt file for adding to a MySQL DB

I'd say you want to write a script to parse your input to produce an input file for the MySQL command load data local infile [filename] into [tablename].

Parsing the data looks simple enough .. the first line has an IP address and a server name, the second has a port number and a service, and the third (if it exists) has the description. Piece of cake; as you get enough info for each record, dump it out using tabs to separate fields (fewer issues than using commas). Check the output file for correctness then load it into the database.

--t. alex

"There was supposed to be an earth-shattering kaboom!" --Marvin the Martian