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.
Best way to delete events
Best way to delete events
Andy
o||||o
Ubuntu 22.04
ZM 1.36.33
E5-1650-v4 Xeon
16 GB RAM
6 cameras -> 54 FPS modect
o||||o
Ubuntu 22.04
ZM 1.36.33
E5-1650-v4 Xeon
16 GB RAM
6 cameras -> 54 FPS modect
-
- Posts: 1213
- Joined: Sat Aug 31, 2019 7:35 am
- Location: San Diego
Re: Best way to delete events
I may misunderstand, but I just copy the monitors table - the rest seems to take care of itself.
Re: Best way to delete events
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...
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
o||||o
Ubuntu 22.04
ZM 1.36.33
E5-1650-v4 Xeon
16 GB RAM
6 cameras -> 54 FPS modect
-
- Posts: 1213
- Joined: Sat Aug 31, 2019 7:35 am
- Location: San Diego
Re: Best way to delete events
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.
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.