Zoneminder database structure

iservetech · Post by **iservetech** » Mon Jan 23, 2006 6:59 pm

I am curious about the functionality of the mysql database in storing events recorded by zone minder. The zone minder program seems to store the jpg files for the events in /var/www/html/zm/events/, so what does the mysql zm.Events table hold? The fields in the Events table show me EventID numbers, but no jpeg filename field. I am guessing the mysql db is used for storing meta data for referencing the dir where the jpg’s are stored, but if someone knows for sure I would appreciate a bit more clarity on this subject

Also, does anyone know how to set zoneminder up to purge the events once disc space reaches a certain capacity?

iservetech · Post by **iservetech** » Mon Jan 23, 2006 7:15 pm

I apologize, I found the PurgeWhenFull Filter, but I am still curious about the mysql functionality .

jameswilson · Post by **jameswilson** » Mon Jan 23, 2006 10:21 pm

mysql is used to basicxally catalouge the massive amount of infomation, ie what frame form what time is called what. If zm just stored images as sequential names reviewing anything would be a nightmare if at all possible!

SyRenity · Post by **SyRenity** » Tue Jan 24, 2006 8:01 am

Hi.

I think that the "Frames" table holds all the recorded events frames. It doesn't hold the paths to the jpgs files thought, but rather indexes, as James correctly said. ZM maps these indexes to the jpgs based on it's internal file structure.

Perhaps Phil can correct me, if I'm wrong?