Page 1 of 1

Manual MySQL deletion

Posted: Wed Sep 19, 2007 5:53 pm
by jamescollings
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!

Posted: Wed Sep 19, 2007 6:35 pm
by zoneminder
zmaudit should clean all the Stats and Frames tables up- for you.

Posted: Wed Jan 26, 2011 7:14 pm
by grndamgt4
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.