Jon Erik Ween

Hi there I'm setting up a mysql database to catalogue my photos to run through a php interface to a browser. I'd like to include a thumbnail so I can categorize, rate and otherwise find my stuff reliably and interact with Photos on a mac and various editing tools. So, need to figure out how to get the output from "exiftool -r -T -b -filename -Thumbnailimage > TN.txt" into mysql but the format of the -ThumbnailImage output gets tricky with mysql "LOAD DATA". I've seen some posts using perl, though...