Restore date from Centreon MBI¶

Restore data from Centreon MBI Server¶

Restore process is divided in several steps:

Reinstalling centreon-bi-server module in the same version that saved.
Integration of generated reports.
Integration of custom reports settings.
Integration of Centreon MBI configuration data.
Integration of MySQL data.
Delete the data from the extracted backup.
Reinstall the backup package.

Reinstalling centreon-bi-server module in the same version that saved¶

On the main Centreon server run the following command:

# yum install centreon-bi-server-3.x.y

Integration of generated reports¶

Get the last centreon-bi-front-reports-and-custom-conf-aaaa-mm-jj.tar.gz backup and extract it into /tmp directory:

# cd /tmp
# tar xzf centreon-bi-front-reports-and-custom-conf-2015-04-27.tar.gz

Then copy backup reports:

# /bin/cp -rf /tmp/var/lib/centreon/centreon-bi-server/archives/* /var/lib/centreon/centreon-bi-server/archives

Note

If the directory is different is that the default settings have been changed by the user. Simply take the right path.

Change rights on directory

::: # chown -R centreonBI:centreonBI /var/lib/centreon/centreon-bi-server/archives

Integration of custom reports settings¶

Get the last centreon-bi-front-reports-and-custom-conf-aaaa-mm-jj.tar.gz backup and extract it into /tmp directory:

# cd /tmp
# tar xzf centreon-bi-front-reports-and-custom-conf-2015-04-27.tar.gz

Then copy saved settings

::: # /bin/cp -rf /tmp/usr/share/centreon/www/modules/centreon-bi-server/configuration/generation/xsl/* /usr/share/centreon/www/modules/centreon-bi-server/configuration/generation/xsl # /bin/cp -rf /tmp/var/lib/centreon/centreon-bi-server/reports/infos/* /var/lib/centreon/centreon-bi-server/reports/infos

Change rights on directory

::: # chown -R apache:apache /usr/share/centreon/www/modules/centreon-bi-server/configuration/generation/xsl

Integration of Centreon MBI configuration data¶

Insert SQL backup using command:

# mysql -u root -p centreon_storage < /tmp/var/backup/dump_centreon_storage.sql

Delete the data from the extracted backup¶

Delete extracted data from backup:

# cd /tmp
# rm -Rf /tmp/usr
# rm -Rf /tmp/var

Restore settings of Centreon MBI Reporting Server¶

Restore process is divided in several steps:

Reinstalling centreon-bi-reporting-server module in the same version that saved.
Integration of CBIS configuration.
Integration of custom reports templates.
Restart CBIS engine.
Delete the data from the extracted backup.
Reinstall the backup package.

Reinstalling centreon-bi-reporting-server module in the same version that saved¶

On the main Centreon server run the following command:

# yum install centreon-bi-engine-3.x.y

Integration of CBIS configuration¶

Get the last centreon-bin-reports-and-conf-aaaa-mm-jj.tar.gz backup and extract it into /tmp directory:

# cd /tmp
# tar xzf centreon-bin-reports-and-conf-2015-04-27.tar.gz

Then copy settings:

# /bin/cp -rf /tmp/etc/centreon-bi/* /etc/centreon-bi

Integration of custom reports settings¶

Get the last centreon-bin-reports-and-conf-aaaa-mm-jj.tar.gz backup and extract it into /tmp directory:

# cd /tmp
# tar xzf centreon-bin-reports-and-conf-2015-04-27.tar.gz

Then copy templates of reports:

# /bin/cp -rf /tmp/usr/share/centreon-bi/reports/* /usr/share/centreon-bi/reports
# chown -R centreonBI:centreonBI /usr/share/centreon-bi/reports
# /bin/cp -rf /tmp/usr/share/centreon-bi/Resources/* /usr/share/centreon-bi/Resources
# chown -R centreonBI:centreonBI /usr/share/centreon-bi/Resources

Integration of MySQL data¶

Stop MySQL service ::

# service mysql stop

Remove the directory /var/lib/mysql from the reporting server::

# rm -rf /var/lib/mysql

Extract the last total backup ( Created by default on Sunday )::

# tar -xzf /var/backup/mysql-centreon_storage-bi-xxxx-xx-xx.tar.gz -C /

Extract all incremental backups cretaed between the last total backup and the date of the day, from the oldest to the most recent via the command ::

# tar -xzf /var/backup/mysql-centreon_storage-bi-xxxx-xx-xx.tar.gz -C /

Change rights on the directory /var/lib/mysql ::

# chown -R mysql:root /var/lib/mysql

Start MySQL service::

# service mysql start

Restart CBIS engine¶

Restart the CBIS using command:

#service cbis restart
Stopping Centreon MBI scheduler : cbis
Waiting for cbis to exit .. done.
Starting Centreon MBI scheduler : cbis
Service started...

Delete the data from the extracted backup¶

Delete extracted data from backup:

# cd /tmp
# rm -Rf /tmp/usr
# rm -Rf /tmp/var