Page 1 of 1

NDO DB purge for nagios

Posted: Sat Mar 03, 2012 1:03 pm
by savage22
Hello,
I am hoping that this is the right place to ask this question, but has any out there used the ndo DB for Nagios and have purged
the MySQL DB before?
Please adivse because our DB is getting very large and is need of purging.
The MySQL DB is awesome to use for Centron on top of Nagios, but I have not been
able to find any sort of purgeing script for the NDO Database tables.
Thank you much.

Re: NDO DB purge for nagios

Posted: Sun Mar 04, 2012 3:36 pm
by mguthrie
Here's an example:

Code: Select all

mysql -u ndoutils -p'password' nagios -e 'TRUNCATE TABLE nagios_logentries'
mysql -u ndoutils -p'password'  nagios -e 'TRUNCATE TABLE nagios_notifications'
Running these commands will clear all entries from the affected tables.