First of all, it will be necessary to have a security copy of the Pandora FMS database where the deleted information is still located. Once recovered in another machine, we will have to take out all the tables that correspond to the Pandora FMS alert system with the following command:
mysqldump pandora --tables talert_actions talert_commands talert_snmp talert_snmp_action talert_special_days talert_template_module_actions talert_template modules talert_templates -u root -p >> talerts.sql;
Where pandora
will be the name of the Pandora FMS database, root
the user with privileges inside it and talerts.sql
the name of the file to recover.
Once the file is obtained, we will enter in the Pandora FMS production database and we will use the command:
source PATH/talerts.sql;
Being PATH the path where we have passed the previous file and talerts.sql
the name of the file.