How to recover an installation from a backup

In case we have to repair our Pandora FMS server and we have lost the data from the console and database, we will have to do the following:

Console recovery

If we have a backup of the console it would do the following:

• If we have a pandora_console directory already created:

[root@PandoraFMS ~]# tar xvzf pandora_console_backup.tar.gz
[root@PandoraFMS ~]# yes | cp -rf pandora_console/* /var/www/html/pandora_console

• If we do not have any pandora_console directory.

[root@PandoraFMS ~]# cd /var/www/html
[root@PandoraFMS html]# tar xvzf pandora_console_backup.tar.gz

In case of not being able to access to the console, check the permissions of its apache user in the directory and in a recursive way.

With these steps we would have already recovered the Pandora FMS console.

Database recovery

For this recovery we need the database backup, once we have it we must do the following:

• Access the MySQL shell.

[root@PandoraFMS ~]# mysql -u pandora -p
mysql >

Once we get inside we will have to create the database in case it is not created:

mysql > create database pandora;
mysql > use pandora;

Once the database is created, we will have to load the backup.

mysql > source /path/backup/backup_pandora.sql;

(This action can take time.)

Once the backup has been loaded, we will only have to check in the console if all the data have been loaded correctly.

If everything is correct, we would have already restored the database, otherwise we would only have to check the pandora user’s permissions on the database.