Outputting to a MySql DB

Started by scrivocmdivo, March 20, 2011, 03:50:11 PM

Previous topic - Next topic

scrivocmdivo

Has anybody had any joy outputting the results of ExifTool to a MySql DB? I am looking at scanning thousands of images and I'd prefer for the results to be written to a MySql DB.

Any suggestions?

Phil Harvey

Reading FAQ number 12 may help.  It discusses techniques to use exiftool to export information to a database.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

Mauricio Villablanca

I wrote a PHP script that calls exiftool with -j option (json string) on the server. The script parses the json and adds the elements to a SQL Server database.

To automate the process, I wrote a windows service that runs the PHP script at a given interval.

It's slow but it works.