You may want to take a look at Text::xSV by our own tilly. This works like Text::CSV but handles embedded newlines. If you import your data into perl with Text::xSV you could then export it in a format more suitable for MySQL (perhaps using quoted fields as gt8073a already pointed out.