Manual MySQL deletion

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

Manual MySQL deletion

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!

User avatar
zoneminder
Site Admin
Posts: 5220
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

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

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 » 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.

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests