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-x.y.z

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-YYYY-MM-DD.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-YYYY-MM-DD.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-x.y.z

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-YYYY-MM-DD.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-YYYY-MM-DD.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 ::

# systemctl stop mysql

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::

# systemctl start mysql

Restart CBIS engine

Restart the CBIS using command:

# systemctl restart cbis
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