Page 1 of 1

Best way to delete events

Posted: Mon Aug 08, 2022 6:26 pm
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.

Re: Best way to delete events

Posted: Mon Aug 08, 2022 11:03 pm
by dougmccrary
I may misunderstand, but I just copy the monitors table - the rest seems to take care of itself.

Re: Best way to delete events

Posted: Mon Aug 08, 2022 11:46 pm
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...

Re: Best way to delete events

Posted: Tue Aug 09, 2022 1:56 am
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.