Manual MySQL deletion

jamescollings · Post by **jamescollings** » Wed Sep 19, 2007 5:53 pm

I am doing some more fine tuning of my zones. I have around 4000 events with associated stats.

If I manually delete the events using MYSQL, will the Stats be deleted automatically by zmaudit in the same way that the on-disk copies will be?

Or

Will manual deletion of either the Stats and/or the Events lead to a corruption of the database?

Your (expert) advice is welcome!

Post by **zoneminder** » Wed Sep 19, 2007 6:35 pm

zmaudit should clean all the Stats and Frames tables up- for you.

grndamgt4 · Post by **grndamgt4** » Wed Jan 26, 2011 7:14 pm

thank you for posting. I have a problem where the zoneminder filters will not delete events, though I can manually check them and delete them.
http://www.zoneminder.com/forums/viewto ... 7269#67269

Your answer allowed me to delete 4200 events via sql vs doing it 1 page at a time in the UI. Thanks.