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?
Reading FAQ number 12 (https://exiftool.org/faq.html#Q12) may help. It discusses techniques to use exiftool to export information to a database.
- Phil
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.