This article describes how to manually backup and restore the databases in Nagios XI.
This article is an advanced topic that can result in data loss if not followed correctly.
If you are looking for an easy backup and restore method please read this article:
Documentation - Backing Up And Restoring Your Nagios XI System
MySQL / MariaDB Databases
nagios database (ndo2db)
mysqldump -uroot -pnagiosxi --add-drop-database nagios > /tmp/nagios_export.sql
nagiosql database (Core Configuration Manager)
mysqldump -uroot -pnagiosxi --add-drop-database nagiosql > /tmp/nagiosql_export.sql
nagiosxi database (XI program and user preferences)
Note: This is only applicable for fresh installs of XI 5.x onwards. If you upgraded to XI 5.x from a previous version please refer to the PostgreSQL steps below.
mysqldump -uroot -pnagiosxi --add-drop-database nagiosxi > /tmp/nagiosxi_export.sql
PostgreSQL Database
Note: This is only applicable for versions of XI before 5.x OR if you upgraded to XI 5.x from a previous version. Fresh installs of XI 5.x onwards do not use PostgreSQL
pg_dump -c -U nagiosxi nagiosxi > /tmp/nagiosxi_export.sql
MySQL / MariaDB Databases
nagios database (ndo2db)
mysql -uroot -pnagiosxi nagios < /tmp/nagios_export.sql
nagiosql database (Core Configuration Manager)
mysql -uroot -pnagiosxi nagiosql < /tmp/nagiosql_export.sql
nagiosxi database (XI program and user preferences)
Note: This is only applicable for fresh installs of XI 5.x onwards. If you upgraded to XI 5.x from a previous version please refer to the PostgreSQL steps below.
mysql -uroot -pnagiosxi nagiosxi < /tmp/nagiosxi_export.sql
PostgreSQL Database
Note: This is only applicable for versions of XI before 5.x OR if you upgraded to XI 5.x from a previous version. Fresh installs of XI 5.x onwards do not use PostgreSQL
psql nagiosxi nagiosxi < /tmp/nagiosxi_export.sql
This command will generate a lot of output.
In certain circumstances you have have a corrupt database and do not have a complete backup using our standard backup procedure. Fortunately the databases themselves are backed up regularly and these can be used to perform the restore. These backups are stored in the /store/backups/ directory.
MySQL / MariaDB Databases
nagios database (ndo2db)
cd /tmp
cp /store/backups/mysql/daily/nagios/nagios_2016-03-27_07h00m.Sunday.sql.gz /tmp/
gunzip nagios_2016-03-27_07h00m.Sunday.sql.gz
mysql -uroot -pnagiosxi nagios < /tmp/nagios_2016-03-27_07h00m.Sunday.sql
nagiosql database (Core Configuration Manager)
cd /tmp
cp /store/backups/mysql/daily/nagiosql/nagiosql_2016-03-27_07h00m.Sunday.sql.gz /tmp/
gunzip nagiosql_2016-03-27_07h00m.Sunday.sql.gz
mysql -uroot -pnagiosxi nagiosql < /tmp/nagiosql_2016-03-27_07h00m.Sunday.sql
nagiosxi database (XI program and user preferences)
Note: This is only applicable for fresh installs of XI 5.x onwards. If you upgraded to XI 5.x from a previous version please refer to the PostgreSQL steps below.
cd /tmp
cp /store/backups/mysql/daily/nagiosxi/nagiosxi_2016-03-27_07h00m.Sunday.sql.gz /tmp/
gunzip nagiosxi_2016-03-27_07h00m.Sunday.sql.gz
mysql -uroot -pnagiosxi nagiosxi < /tmp/nagiosxi_2016-03-27_07h00m.Sunday.sql
PostgreSQL Database
Note: This is only applicable for versions of XI before 5.x OR if you upgraded to XI 5.x from a previous version. Fresh installs of XI 5.x onwards do not use PostgreSQL
cd /tmp
cp /store/backups/postgresql/daily/postgres/postgres_2016-03-27.Sunday.sql.gz /tmp/
gunzip postgres_2016-03-27.Sunday.sql.gz
psql nagiosxi nagiosxi < /tmp/postgres_2016-03-27.Sunday.sql
This command will generate a lot of output.
For any support related questions please visit the Nagios Support Forums at:
http://support.nagios.com/forum/
Article ID: 492
Created On: Thu, Mar 31, 2016 at 11:57 PM
Last Updated On: Thu, Mar 31, 2016 at 11:57 PM
Authored by: tlea
Online URL: https://support.nagios.com/kb/article/nagios-xi-manual-backup-and-restore-databases-492.html