Best way to delete events

Discussions related to the 1.36.x series of ZoneMinder
Post Reply
User avatar
Andyrh
Posts: 238
Joined: Sat Oct 28, 2017 3:55 am

Best way to delete events

Post by Andyrh »

What is the best way to remove events after I copy my DB to my upgrade test VM? I have been running zmaudit.pl.
This (I think) has resulted in ZM not starting one time.
Andy
o||||o

Ubuntu 22.04
ZM 1.36.33
E5-1650-v4 Xeon
16 GB RAM
6 cameras -> 54 FPS modect
dougmccrary
Posts: 1150
Joined: Sat Aug 31, 2019 7:35 am
Location: San Diego

Re: Best way to delete events

Post by dougmccrary »

I may misunderstand, but I just copy the monitors table - the rest seems to take care of itself.
User avatar
Andyrh
Posts: 238
Joined: Sat Oct 28, 2017 3:55 am

Re: Best way to delete events

Post by Andyrh »

I grab the entire config so I know the test is valid, and to make sure I can recover. Does the monitor table get all of the settings or just the monitors?

I had not thought about not grabbing everything, I am not a DBA...
Andy
o||||o

Ubuntu 22.04
ZM 1.36.33
E5-1650-v4 Xeon
16 GB RAM
6 cameras -> 54 FPS modect
dougmccrary
Posts: 1150
Joined: Sat Aug 31, 2019 7:35 am
Location: San Diego

Re: Best way to delete events

Post by dougmccrary »

I am not a DBA...me neither.

I believe everything specific to each monitor is in there. But I haven't looked in a while, and don't know why it would have changed.
You could try it.
Probably system stuff from the options pages are not there.
Post Reply