NDO DB purge for nagios

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

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