Nagios Support Forum

Posted: **Sat Mar 03, 2012 1:03 pm**

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.

Posted: **Sun Mar 04, 2012 3:36 pm**

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.

Nagios Support Forum

NDO DB purge for nagios

NDO DB purge for nagios

Re: NDO DB purge for nagios