MYSQL database Extraction

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
network2016
Posts: 47
Joined: Tue Mar 08, 2016 11:35 am

MYSQL database Extraction

Post by network2016 »

Hi ,

I am looking to export the MySQL database from nagios , please help me to understand where the MySQL files are stored in nagios [in which directory] , Please advise how to download the table into computer in XML or text files.


Regards
dwhitfield
Former Nagios Staff
Posts: 4583
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN
Contact:

Re: MYSQL database Extraction

Post by dwhitfield »

I know you asked about MySQL, but it's possible you will need postgres information too. Here's the complete KB: https://support.nagios.com/kb/article.php?id=492
network2016
Posts: 47
Joined: Tue Mar 08, 2016 11:35 am

Re: MYSQL database Extraction

Post by network2016 »

I am using nagios5.4.2 so PostgreSQL is not supported in that ? correct me if i am wrong ..

But Thanks it helped me in extracting mysql data indeed .


Thanks
dwhitfield
Former Nagios Staff
Posts: 4583
Joined: Wed Sep 21, 2016 10:29 am
Location: NoLo, Minneapolis, MN
Contact:

Re: MYSQL database Extraction

Post by dwhitfield »

network2016 wrote:I am using nagios5.4.2 so PostgreSQL is not supported in that ?
It depends. If it was a fresh install of 5.4.2 rather than an upgrade, that is correct.

It sounds like this issue has been resolved. Is it okay if we lock this thread? Thanks for choosing the Nagios forums!
Locked