THIS KNOWLEDGE BASE HAS BEEN ARCHIVED AND IS NO LONGER BEING UPDATED
Please visit library.nagios.com/docs for the latest and most up-to-date documentation.
Home » Categories » Multiple Categories

Nagios XI - Manual Backup And Restore Databases

Overview

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

 

Backup

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

 

 

Restore

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.

 

 

Emergency Restore

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.

 

 

Final Thoughts

For any support related questions please visit the Nagios Support Forums at:

http://support.nagios.com/forum/



Special Offer For Knowledgebase Visitors! Get a huge discount on Nagios Log Server by clicking below.

Get 60% Off Nagios Log Server!

Did you know? Nagios provides complete monitoring of: Windows, Linux, UNIX, Servers, Websites, SNMP, DHCP, DNS, Email, Storage, Files, Apache, IIS, EC2, and more!

3 (2)
Article Rating (2 Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Parent/Child Host Relationships
Viewed 12734 times since Mon, Jun 28, 2021
Nagios XI - How To Test Check Commands From The Command-line
Viewed 57033 times since Tue, Jan 26, 2016
Nagios XI - Hardware Requirements - Baseline Testing
Viewed 9147 times since Sun, Jul 17, 2016
Nagios XI - Using The Config Import Prep Tool
Viewed 14778 times since Thu, Jan 28, 2016
Nagios XI - Mod-Gearman Queues and Workers
Viewed 52161 times since Fri, Mar 4, 2016
Viewing Configuration Snapshot differences
Viewed 4214 times since Fri, Dec 4, 2020
Nagios XI - Group Deployment of Service Checks - NWC15
Viewed 9168 times since Mon, Feb 8, 2016
Nagios XI - Restarting A Linux Service With NRPE
Viewed 10970 times since Thu, Jan 28, 2016
Nagios XI - Using the Negate Plugin
Viewed 10597 times since Thu, Jan 28, 2016
Nagios XI - Understanding User Macros
Viewed 9773 times since Thu, Jan 28, 2016