Manual MySQL deletion

Support and queries relating to all previous versions of ZoneMinder
Locked
jamescollings
Posts: 59
Joined: Wed Nov 22, 2006 11:26 am
Location: Bucks, UK

Manual MySQL deletion

Post 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!
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Post by zoneminder »

zmaudit should clean all the Stats and Frames tables up- for you.
Phil
grndamgt4
Posts: 24
Joined: Tue Oct 13, 2009 5:05 pm

Post 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.
Locked