Manually restore the nagios(xi)db(s)

[benhank]

hey fellas!
i need to figure export Nagios's DB and restore it to another. I saw documentation that detailed this a while ago, but cant find it now. I'm trying to do this on 2014 version.

[rkennedy]

Just to make sure, do you know if the server is actually utilizing MySQL? I believe 2014 still used Postgres.

[benhank]

Yeah I think it uses both

[ssax]

To backup MySQL to file:

Code: Select all

mysqldump -uroot -pnagiosxi --add-drop-database nagios > /tmp/nagios_export.sql
mysqldump -uroot -pnagiosxi --add-drop-database nagiosql > /tmp/nagiosql_export.sql

To restore MySQL from file:

Code: Select all

mysql -uroot -pnagiosxi nagios < /tmp/nagios_export.sql
mysql -uroot -pnagiosxi nagiosql < /tmp/nagiosql_export.sql

To backup PostgreSQL to file:

Code: Select all

pg_dump -c -U nagiosxi nagiosxi > /tmp/nagiosxi_export.sql

To restore PostgreSQL from file:

Code: Select all

psql nagiosxi nagiosxi < /tmp/nagiosxi_export.sql

[benhank]

ok thanks ! dont lock it till I test ok?

[hsmith]

Sounds good.

[benhank]

ok cool the export worked thanks guys!